MySQL Upgrade - Lessons Learned

Database Administration
2 April 2:20PM - 3:10PM @ Ballroom F

Experience level: 
Beginner
Duration: 
50 minutes conference
Are you still running a huge monolithic 5.0 MySQL database in production? Afraid of upgrading? Intended for inexperienced DBAs, this talk will chart the path we took at LeadRocket to upgrade our production instances from Percona 5.0 to 5.5. In the process we had to deal with conversion of a near-terabyte 5.0 innodb database to file-per-table, we discovered the effect of non-deterministic queries and dealt with data drift between production and upgraded instances. Using tools like pt-table-checksum and pt-query-analyzer we were able to shrink our database by 30%, make it more flexible and easier to administer, and easier to back up and replicate. If you haven't experienced this pain before, come learn from ours - before you embark on your upgrade adventure.


Speakers

VP Technical Operations, Genius.com Inc
Biography: 
Chief DBA in a multi-homed, multi-master, many slave high transaction mixed Percona 5.0 and 5.5 environment.