Release Notes - MySQL 5.6
Posted by on 24 July 2013 02:13 PM
Overview - MySQL 5.6 (CentOS 6 only)
This Release Note covers all point releases for the MySQL 5.6 branch that are offered by eApps. Upgrade instructions are also included.
NOTE - eApps only maintains MySQL Server 5.6 for CentOS 6 OS Templates. Virtual Servers using CentOS 7 OS Templates will use MariaDB, which is a drop in replacement for MySQL. Please see the MariaDB User Guide for more information. If you are on a CentOS 6 OS Template and want to move to a CentOS 7 OS Template, please contact eApps Sales.
eApps recommends, as a best practice, to maintain a staging server where you can test software upgrades before moving them into production. This approach will allow you to minimize the risk of data loss and downtime of your production service when performing software upgrades. If necessary, you can rebuild your staging Virtual Server on demand so that you have a fresh installation to test on. If you need more information about setting up a staging Virtual Server, please contact eApps Sales.
IMPORTANT! MySQL version 5.6 has an extensive list of new features and changes. Upgrading to this version may significantly impact the operation of your database. The official What is New in MySQL 5.6 documentation is located here - http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html. Please read this to understand all of the changes in the MySQL 5.6 release. For additional information, the official documentation for MySQL is located here - http://dev.mysql.com/doc/
eApps Release Notes for MySQL 5.6.27
Highlighted Features and Fixes in MySQL 5.6.27
The official Release Notes for MySQL 5.6.27 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-27.html
Highlighted Features and Fixes in MySQL 5.6.25
The official Release Notes for MySQL 5.6.25 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-25.html
Highlighted Features and Fixes in MySQL 5.6.24
The official Release Notes for MySQL 5.6.24 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-24.html
Highlighted Features and Fixes in MySQL 5.6.22
NOTE - the Replication variable
The official Release Notes for MySQL 5.6.22 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-22.html
Highlighted Features and Fixes in MySQL 5.6.21
NOTE - the
The official Release Notes for MySQL 5.6.21 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-21.html
Highlighted Features and Fixes in MySQL 5.6.20
NOTE - several important changes/fixes to the behavior of DROP TABLE have been implemented. Please read the official Release Notes (linked to below) for more information.
The official Release Notes for MySQL 5.6.20 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
Highlighted Features and Fixes in MySQL 5.6.17
WARNING - There are several incompatible changes with previous versions of MySQL that are included in this release. Please read the official Release Notes for more details. These changes are in place in preparation for MySQL 5.7, the next major release.
Some of the incompatible changes are:
The official Release Notes for MySQL 5.6.17 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-17.html
Highlighted Features and Fixes in MySQL 5.6.12
The official Release Notes for MySQL 5.6.12 are available here - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-12.html
How to upgrade
To upgrade MySQL, you will need to work from the command line using SSH, and you will need to be able to work as the root user. You will need to use yum to upgrade the application. You will also need to know the root password for the MySQL server (not the super user root password).
MySQL 5.1 to MySQL 5.6
There is no direct upgrade path between major MySQL releases, such as between MySQL 5.1 and MySQL 5.6. In order to upgrade, you will need to export your databases, uninstall MySQL, move your existing data and configuration files, update the mysql libraries and client, install the new version of MySQL, and then import your databases. If you have custom configurations that are still compatible with MySQL 5.6, you will need to move those back into place.
NOTE - If you try to update MySQL without following these steps, the upgrade will fail, and you may encounter data loss due to database corruption.
Export your databases
To export your databases, use the
Uninstall MySQL server
To uninstall the MySQL server, use the
You will be asked to confirm that you wish to remove the package, answer y.
Move the existing mysql directory and configuration file
The update to MySQL 5.6 will install a new mysql directory and my.cnf file. If your existing mysql directory and configuration file are still in place, the new version of MySQL will not start.
To do this, you will need to use the
Update the mysql libraries and client
Along with the MySQL server, the MySQL libraries and client application have to be updated. Updating the MySQL libraries will update the MySQL client at the same time.
To update the libraries and client, use the
You will be asked to confirm that you wish to update two packages, answer y.
Install the new version of the MySQL server
After updating the MySQL libraries and client, you will need to install the new version of the MySQL server. This is done with the
You will be asked to confirm that you wish to install two packages, answer y.
Start the MySQL server
After the installation completes, you will need to start the MySQL server.
Import your databases and restart MySQL
After the upgrade is complete, you will need to import your databases back into MySQL, and then restart the MySQL server. Import your databases back into MySQL with the
Once you have imported the databases, restart MySQL.
You should now be able to access MySQL as the MySQL root user, with the correct password.
Update your MySQL configuration file
As part of the upgrade process, you moved the my.cnf configuration file to a new location (my.cnf_orig). If you had made any changes to the original my.cnf, please review the official MySQL 5.6 documentation before adding those changes to the new my.cnf file. Some of the configuration parameters may have changed, and using an older value may cause issues with the new version of MySQL.
If you are not sure, move your custom configurations from the original my.cnf file into the new my.cnf file one at a time, and restart MySQL after each addition. If MySQL fails to start, then you know that particular configuration is not compatible with the new version.
MySQL 5.6.x to MySQL 5.6.y (newer version of MySQL 5.6)
To update MySQL you will need to connect to your Virtual Machine via SSH. Once you are connected to the Virtual Machine, you will need to run the following commands as the root user:
You will know that the new version of MySQL is installed when you see a Complete! message and you are returned to the command prompt. Once the installation has completed, restart MySQL.