How CloudStats.me moved from MySQL to clustered MariaDB for high availability

Andrey Vasilyev
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "How CloudStats.me moved from MySQL to clustered MariaDB for high availability", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

CloudStats.me is a fast growing cloud-based server and website monitoring service. The rapid growth of the CloudStats user base and the number of services being monitored created a significant load on its MySQL infrastructure. The system ingests large amounts of incoming metrics/event data collected by thousands of agents. The backend systems also perform analytics on large portions of that data, and alerts are triggered as soon as certain conditions are met.

Agenda

  • CloudStats.me infrastructure overview
  • Database challenges
  • Limitations in cloud-based infrastructure
  • Scaling MySQL - many options (MySQL Cluster, Master-Slave Replication, Sharding, etc)
  • Availability and failover
  • Application sharding vs auto-sharding
  • Migration to MariaDB / Galera Cluster with ClusterControl + NoSQL
  • Load Balancing with HAProxy/MaxScale
  • Infrastructure set up provided to CloudStats.me (Private Network, Cluster Nodes, H/W SSD Raid + BBU)
  • What we learnt - “Know your data!”
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.