Upgrading MySQL is boring topic, upgrading MySQL is something we would rather to be done with and get benefits from new cool features or be done with bugs and limitations which haunted us for years. Yet if you’re not careful performing MySQL upgrade you can get advantage of multiple opportunities of downtime and data loss, which come as just some of the risks. There is also one special thing about upgrades – unlike many other tasks DBA has to do, major version upgrade is done only once, at least once for every environment and every major version upgrade has its own issues. At Percona we’ve dealt with many MySQL Upgrades, in some cases we’re asked to Perform upgrade completely, in others to assist/advice on doing upgrade, finally we can be called to resolved failed upgrades which, can be all kinds of issues when upgrade is not done carefully.
On June 27, I’ll talk about some of best practices Percona had developed over years in relation to MySQL Upgrade. See you there.