Loading…
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Wednesday, May 12 • 09:00 - 09:30
Scaling MySQL @LinkedIn with Vitess

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.


MySQL serves as the datastore for many of the important internal tools at LinkedIn. A typical MySQL cluster at LinkedIn has 1 primary and 2 replicas for read-scaling and High Availability. To scale the reads for all these tools, more replicas are added to the cluster. But, what about write-scaling which still goes to a single primary?

We started looking for an answer to this question about a year and a half ago when one of the tools ramped up quickly and was struggling due to writes. When we decided sharding as the solution to this, there was a choice between writing the sharding logic in the application itself or choosing Vitess.

Vitess stood out for us. Although we had to tweak the schema design, there were minimal changes to the application code as it supports almost all the SQL queries and connection pooling.

This talk will be focused about our journey with Vitess. We will take the attendees through the ‘Why’ of our journey, why we chose Vitess and not any other sharding method; how we migrated the platform real time and what tremendous metrics we achieved post successful migration.

The talk will consist of:-
- Introduction
- Why Vitess?
- Brief Introduction to Vitess
- Challenges while moving to Vitess
- What it looks like at the Infra-level
- Key Achievements

Along with talking about our journey with Vitess, we will touch base upon what is next for Vitess@LinkedIn.

Key Takeaways
- Vitess as a sharding solution to MySQL
- Insights from our learnings

Speakers
avatar for Apoorv Purohit

Apoorv Purohit

SRE, LinkedIn
I started my career as an application developer in 2016 handling C++ telephony module and report generation from MySQL. With my growing interest in databases, I switched to become a full time database engineer in 2017 at OneDirect. I was a part of the team that handled the entire... Read More →
avatar for Karthik Appigatla

Karthik Appigatla

Staff SRE, LinkedIn
Karthik Appigatla has been working on various large scale data stores for a decade primarily focused on MySQL. Currently, he has been working for LinkedIn for the last 5 years. Prior to LinkedIn, he worked for Yahoo, Pythian and Percona where he was responsible for helping clients... Read More →


Wednesday May 12, 2021 09:00 - 09:30 EDT
Room #6