Sunday, January 20, 2019

Managing 500+ MySQL servers in the AWS cloud

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