Pythian Speaking at MySQL Conference 2011

Posted in: Technical Track

MySQL Conference 2011, Santa Clara, CA – April 10-14, 2011

Session TitleSpeakerDate/TimeLocationAbstract
Dealing with Schema Changes on Large Data VolumesDanil ZburivskyTuesday, April 12, 2011 – 2pmBallroom CSchema 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 ShardingGwen ShapiraWednesday, April 13, 2011 – 5:15pmBallroom ESharding 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.

Interested in working with Vanessa? Schedule a tech call.

About the Author

Vanessa is an experienced business development professional with over 15 years’ experience in all aspects of the business development and marketing disciplines. She brings endless energy, drive, and a results-oriented approach to creating Pythian’s strategic partnerships and business initiatives. In her spare time, Vanessa pursues her passion for great food, wine, and artisan cheeses as an accredited Cheese Sommelier and Cordon Bleu-trained chef. Her weekly Friday afternoon cheese tastings at Pythian’s Ottawa office aren’t to be missed!

1 Comment. Leave new

Pythian Q2 2011 speaking: MySQL Conference, Collaborate, & more… | The Pythian Blog
March 30, 2011 10:57 am

[…] Speaking Details […]


Leave a Reply

Your email address will not be published. Required fields are marked *