Blog

Geo-Scale MySQL for Continuous Global Operations & Fast Response Times

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.

Watch the webinar replay

We’ve covered this particular use case in a recent webinar. You can watch the replay of the webinar here.

About Tungsten Clustering

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.

About the Author

Jean-Jérôme Schmidt
VP of Marketing

Jean-Jérôme has been an avid open source (database) marketer for most of his career. Prior to joining Continuent, he was VP of Marketing at Severalnines, a leader in automation & management of open source databases, having come from MariaDB, where he headed up marketing as well. Previous roles include Director EMEA Marketing at Pentaho, Global Sales Ops Mgr at MySQL & Commercial Director at marketing agency Connection2. And all that from his home-base in Dublin.

Add new comment