MySQL 8.0 will be GA soon (just my assumption:
Oracle doesn't tell me anything about its release plans) and it's
time to think about having a look at it.
If this is your first try of MySQL 8, get prepared for several
impacting differences from previous versions.
In this article I won't tell you what you can do with MySQL 8: there is plenty of material about this, including in this very blog. I will instead concentrate on differences from previous versions that users need to know if they want to avoid surprises.
Data Directory
Let's start with an observation of the data directory.
After a standard installation, without any additional options, I
see the following:
Files that I expected to see
auto.cnf
ib_buffer_pool
ib_logfile0
ib_logfile1
ibdata1
ibtmp1
(dir) mysql
(dir) …
[Read more]