Geo-scale MySQL – or how to build a global, multi-region MySQL cloud back-end capable of serving several hundred million player accounts
This blog introduces a series of blogs we’ll be publishing over the next few months that discuss a number of different customer use cases that our solutions support and that centre around achieving continuous MySQL operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling.
This first use case looks at a customer of ours who are a global gaming company with several hundred million world-wide player accounts.
What is the challenge?
How to reliably, and fast, cater to hundreds of millions of game players around the world? The challenge here is to serve a game application for a geographically-distributed audience; in other words, a pretty unique challenge.
It requires fast, local response times for read traffic, a limited number of updates, and a single consolidated view of the data across the world, which is very typical for gaming applications, and for all account/subscription management systems in general.
What is the solution?
Continuent Tungsten Clustering. The solution we implemented for this customer is comprised of four (4) geo-distributed Composite Tungsten Clusters, with one active cluster in USA West accepting writes and updates and handling local read traffic, and three passive Tungsten clusters in USA East, EMEA and APAC providing very fast local reads to access the player accounts.
What are the benefits?
The continuous operations. The benefits that this solution provides are clear: geo-scale, availability and disaster recovery.
More specifically, it includes low-latency, geo-distributed data access providing fast response times for read traffic as well as local, rapid-failover automated high availability.
This, combined with simple administration, system visibility and stability also helps create high return on investment.
We’ve covered this particular use case in a recent webinar. You can watch the replay of the webinar here.
Tungsten Clustering allows enterprises running business-critical MySQL database applications to cost-effectively achieve continuous operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling.
To find out more, visit our Tungsten Clustering product page.