Lessons learned managing 500+ MySQL servers in the cloud

Cloud and Virtualization

In this presentation, learn about the issues of managing a large number of instances of MySQL in the cloud, supporting 50 billion SQL statements per day. This presentation will cover the following topics using Amazon Web Services (EC2)

• What is AWS really costing you?
• Learn how to save with reserved and spot instances
• The need for monitoring and instrumentation
• Tricks to automate installations, upgrades, and deployments
• Issues with MySQL’s Replication feature with 300 slaves per master
• Traffic minimization techniques
• Creating high availability with regions and zones
• Real-time traffic stats (aggregated every five seconds)


Ronald Bradford
MySQL Database Consultant, Pythian
Ronald has over 25 years of professional RDBMS experience in MySQL, Oracle, and Ingres. His expertise covers MySQL, LAMP and cloud-based consulting in architecture, performance, scalability and business continuity. Ronald is a former employee of the MySQL Inc consulting team (06-08) and Oracle Corporation (96-99). He has currently published 4 books on MySQL, his most recent titles available from Oracle Press include Effective MySQL: Optimizing SQL Statements, Effective MySQL: Backup & Recovery and Effective MySQL: Replication Techniques in Depth.