The Ubuntu 12.04.3 LTS release only provides MySQL 5.1 and MySQL 5.5 using the default Ubuntu package manager.
Oracle (owners of the MySQL(tm)) now provide Debian/Ubuntu APT repositories for all GA and DMR versions of MySQL including supporting Ubuntu 12.04.
The following steps demonstrate upgrading from the Ubuntu 5.5 server package to the Oracle 5.6 server package.
Verify MySQL Packages
Verify MySQL on Server
Results may vary based on dependencies.
Checking the MySQL error log (as it’s the right good practice to always do)
A check shows that this is not the most current version available of 5.5 using the Ubuntu packages.
Just to be consistent with keeping current versions, you may choose to update MySQL 5.5 to the current available version.
Installing Oracle APT Packaging
The recommended documented way to move to using the Oracle repo is:
This unfortunately uses a cursors based interface which is not something you automate for production systems and not the approach I would suggest.
So doing what this does
Now we can look at available versions.
This is where life gets a little confusing. Because Ubuntu supported MySQL 5.1 (as mysql-server) and MySQL 5.5 (as mysql-server-5.5) it can be misleading.
We are looking to ensure the Maintainer is the Official Release.
Upgrading to MySQL 5.6
You may think the process is completed, but it is not. Always, Always check the error log. Have you checked your MySQL error log today?
Completing the MySQL 5.6 Upgrade
A MySQL upgrade of the meta schema is necessary.
Correcting errors
As you can see there are several warnings/errors when starting MySQL.
The first is
We solve this with
This is an Ubuntu default that conflicts with the my.cnf log_error were are familiar with in monitoring the MySQL error log. You can read my opinion on this in The correct approach to rolling MySQL logs
The second is
We solve this with
Next
We solve this with
The warnings are interesting, and will part of the following post on MySQL 5.6 configuration changes discussed in the next point.
Leveraging MySQL 5.6 benefits
We may now have a MySQL 5.6 installation however we are far from utilizing the benefits of MySQL 5.6 fully. In a subsequent post I will talk about the configuration options we need to now consider, both new options such as innodb_purge_threads and important improvements such as sync_binlog. There are far greater complex changes including innodb_file_per_table, master_info_repository and relay_log_info_repository and then changes in defaults such as performance_schema
PlanetMySQL Voting: Vote UP / Vote DOWN