Buy Percona ServicesBuy Now!

Percona Live Presents: Globalizing Player Accounts with MySQL at Riot Games

 | May 28, 2019 |  Posted In: Events, MySQL, Open Source Databases

PREVIOUS POST

During my presentation at Percona Live 2019, I’ll be talking about how Riot Games, the company behind League of Legends, migrated hundreds of millions of player accounts to unlock opportunities for us to delight players. This meant moving ten geographically distributed databases into a single global database replicated into four AWS regions. I’ll talk about some of the technical decisions we made, the expected vs actual outcomes, and lessons we learned along the way.

Migrating hundreds of millions of player records without impacting a player’s ability to manage their account and log in was a daunting task. I’ll shed some light on how we managed to handle this data migration while modifying the database schema. I’ll also go into detail on the backend architecture of our accounts service, such as how we use Continuent Tungsten, which we’re leveraging to manage our globally replicated database.

I gave a similar version of this talk at AWS re:Invent last year, and wrote the article “Globalizing Player Accounts” on the Riot Games Tech Blog—check out these resources for more deep tech details and context on our accounts solution.

Who’d get the most from this presentation?

The presentation will be most helpful for folks who want to learn about strategies for deploying globally replicated databases, especially developers and DBA/DBEs who are building global services. I’ll also discuss how we think about deploying applications that will talk to these types of databases.

Whose presentations are you most looking forward to?

In particular, I’m really looking forward to VividCortex’s talk on optimizing performance and efficiency because I’d like to see their perspectives on performance issues. I’m excited to learn more by comparing their solutions to the ones I’ve seen at my own company.

I’m also looking forward to the Facebook talks (Part 1 & Part 2) on HA MySQL because I’m interested in this problem space and I’m curious about their solutions for managing data at scale.

 

PREVIOUS POST
Tyler Turk

Tyler is an engineer on the player accounts team at Riot Games. The Player Accounts team is responsible for every player's ability to log in and manage account data. In 2018, we re-architected our systems to become GDPR compliant, provide a better player experience, and enable Riot to become a multi-game company in the future.

Leave a Reply