MySQL Upgrade, Case Study: Upgrade Large DB network from 4.1 to 5.5

6.16667
Average: 6.2 (6 votes)

In 2004 we designed and developed a distributed online loyalty marketing system with a large sharded MySQL network using version 4.1 and MyISAM. We've not been able to upgrade MySQL since then for various reasons. We tried to upgrade three times in the last 3 years with no luck first two attempts. From what we learned in the first two attempts and a lot of planning we've now succeeded with this upgrade. In the process we also made a major jump by upgrading from a 32-bit architecture, MySQL 4.1, MyISAM to a 64-bit architecture, MySQL 5.5, Innodb.

This presentation will discuss the approach we took in upgrading with minimal downtime and lessons learned and problems encountered along the way.

Track: 
Best Practices for Businesses
Experience level: 
Intermediate

Schedule info

Time slot: 
12 April 14:00 - 14:50
Room: 
Ballroom D

Schedule Info

12 April 14:00 - 14:50 @
Ballroom D

Speakers

principal dba, mypoints.com

Database technology specialist with more than 17 years of experience in managing and implementing complex database systems for mission critical applications. Extensive experience working with hundreds of different MySQL production deployments and other big data solutions like Hadoop clusters and Netezza data warehouse.

VP, Technology, MyPoints

Software technology executive with 25 years of experience working with backend technologies using all different database engines and 15 years of experience working in online marketing space. Involved in design and development of distributed scalable marketing system using MySQL backend and other open source technologies.

Slides




Sponsored By