As you can guess, MySQL 8.0 will be the next generation of databases because it will include the traditional side of SQL and NoSQL with JSON. The new features are not just those that I just mentioned; you will also find the following:
- Common table expression (CTE): A type of temporary table associated with a query that will allow you to use the WITH command for recursion.
- Invisible indexes: These are invisible to the MySQL optimizer; that is, they are maintained by the optimizer but not used by it. This has the big advantage of being able to test the behavior of the MySQL 8.0 server during evaluation and not the index.
- Oracle has also added to MySQL 8.0 what are called persisting configuration variables, and this new feature has the ability to make persistent changes to the MySQL configuration online.
- The data dictionary has been optimized, a very good improvement.
- Great features have been added for replication as well.
Let's not forget the new roles that will facilitate user management—and many other surprises besides.