Migrating to MySQL 5.7 – the database upgrade guide

Upgrading to a new major version involves risk, and it is important to plan the whole process carefully. In this white paper, we look at the important new changes in MySQL 5.7 and show you how to plan the test process. We then look at how to do a live system upgrade without downtime. For those who want to avoid connection failures during slave restarts and switchover, this document goes even further and shows you how to leverage ProxySQL to achieve a graceful upgrade process.

What we’ll cover in this white paper

• 1. Introduction
• 2. Changes between MySQL 5.6 and MySQL 5.7
  • 2.1. Information schema changes
  • 2.2. Systemd introduction to RPM-based distros
  • 2.3. SQL modes
  • 2.4. Authentication changes
  • 2.5. Changes in InnoDB
  • 2.6. Other changes introduced in MySQL 5.7
• 3. Overview of test environment
• 4. Pre-upgrade testing
  • 4.1. First step – build a test environment
  • 4.2. Collect data for regression tests
  • 4.3. Regression tests using pt-upgrade
  • 4.4. Regression tests of application
  • 4.5. Bring back the node into replication
• 5. Upgrade
  • 5.1. Slave upgrade process
  • 5.2. Switchover process and upgrade of the old master
• 6. Graceful upgrade process using ProxySQL
  • 6.1. Installation of ProxySQL
  • 6.2. Configuring ProxySQL for graceful switchover with the ClusterControl