Webinar replay: How To Upgrade to MySQL 5.7 - The Best Practices - part 5

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.

AGENDA
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