How to upgrade to MySQL 5.7 – the best practices

MySQL 5.7 has been around for a while now, and if you haven’t done so yet, it’s probably about time to start thinking about upgrading your database to the latest version. There are a few things you need to keep in mind when planning a MySQL upgrade, such as important changes between versions 5.6 and 5.7 as well as detailed testing that needs to precede any such upgrade process for instance. Amongst other things, we’ll look at how to best research, prepare and perform such tests before the time comes to finally start the upgrade process.

Content of the webinar

• Preparation for upgrade – changes between 5.6 and 5.7
  • Information_schema changes
  • SQL modes
  • Changes in authentication model
  • Changes in InnoDB
  • Other changes
• Tests
  • Designing testing environment
  • Building testing environment
  • Performing regression tests using pt-upgrade
  • Performing application tests
• Upgrade process
  • Upgrading slaves
  • Switchover and upgrade of the old master