MySQL 8 Preview

Some of the new features include :

Data dictionary A global data dictionary contains information about database objects in transactional tables rather than being stored in metadata files and nontransactional system tables
InnoDB Changes : Tablespace Encryption Providing data at-rest encryption for physical tablespace data files using Advanced Encryption Standard (AES)
InnoDB Changes : Partitioning Table partitioning is now from within the storage engine which can provide performance gains, but only under certain conditions and depends upon how your disks are configured
Account management Roles are now supported, which are simply a collection of privileges assigned to a user

https://dev.mysql.com/doc/refman/8.0/en/ Reference Manual
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/ Release Notes
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html What is new in a nutshell
https://dev.mysql.com/doc/refman/8.0/en/upgrading.html#upgrade-procedure-inplace Upgrade procedure

Advertisements
This entry was posted in database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s