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
Founder & CEO, EffectiveMySQL
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.