How To Upgrade to MySQL 5.7 - The Best Practices

Presented by
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "How To Upgrade to MySQL 5.7 - The Best Practices", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

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

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

Comments & questions

Have any questions? Please, contact us.