This presentation discusses the lessons learned about the issues of managing a large number of MySQL instances, Including experiences from multiple clients including supporting one billion+ requests statements per day (and 50+ billion SQL statements), and smaller users of LAMP stack, Microsoft stack and RDS configurations. Topics include:
- Monitoring and instrumentation are essential to manage cost
- Cost saving techniques
- How to automate installations, upgrades and deployments
- Traffic minimization techniques
- Creating HA with regions and zones
- Real-time traffic stats (aggregated every 5 seconds)
- AWS specific optimizations with EBS
- Considerations and limitations with RDS
Presenter: Ronald Bradford
Schedule:
- Cloud Expo West – November 2012- Santa Clara, CA. Session Outline.
- MySQL Connect – September 2012 – San Francisco, CA. Session Outline.
