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

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


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++ Networking 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 started his career at Yahoo, where he was responsible for managing most critical databases like advertising, mail, flickr etc. Later he worked as Lead Database consultant at Pythian and then as Sr. Database Consultant at Percona helping clients scale/tune their high-transaction... Read More →


Wednesday May 12, 2021 13:30 - 14:00 EDT
Room #1
Feedback form isn't open yet.