MySQL Conference 2011, Santa Clara, CA – April 10-14, 2011
|Dealing with Schema Changes on Large Data Volumes||Danil Zburivsky||Tuesday, April 12, 2011 – 2pm||Ballroom C||Schema changes are unavoidable in almost any environment. It is hard to imagine any major application change that does not have to change the database. While your database size is small enough this is not a problem. But when your data grows straightforward ALTER TABLE may take hours, which is not acceptable if application uptime is crucial. This session will tell you about two different approaches to this problem. Using master-master setup to apply schema changes on standby machine will eliminate downtime but is not suitable for some kind of changes, like column renaming and column drop. Using “shadow” tables in conjunction with a set of triggers to maintain data consistency will allow you to apply schema changes without taking database offline or failing over to standby server. This session will focus on pros and cons of each approach and describe most common use cases for both.|
|No Silver Bullet – The Slightly Less Painful Way to Sharding||Gwen Shapira||Wednesday, April 13, 2011 – 5:15pm||Ballroom E||Sharding is a pain. Anyone who says differently is trying to sell you something. NoSQL DBs promise to solve the pains involved with sharding at the expense of integrating a whole new technology and data model. In this presentation, Gwen Shapira will share stories from her 13 years of sharding experience: What was painful, which pains can be solved and which are here to stay. Learn how with some advanced planning, understanding of inherent trade-offs and little cooperation between operations and developement you can have less-painful sharded architecture using your favorite relational database.|
Don’t forget, we’re hiring stellar MySQL DBA’s. If this is you, stop by a session above and introduce yourself to Gwen or Danil. They’ll tell you firsthand what it’s like to work at Pythian. Register on our career center for job details, or to receive our newest postings.