Apoorv Purohit and Karthik Appigatla - LinkedIn - Scaling MySQL @LinkedIn with Vitess - Percona Live

#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 #HighAvailability. 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?

Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel 📺, and turn on the 🔔 to be alerted to new videos about #OpenSource #Databases... and many other things!
https://percona.tv/subscribe


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

You can find more information about #OpenSource #Databases and Percona Database Events in these links 👇👇👇

Percona Services ⏩ https://per.co.na/Q8eykw
Watch Percona Live 2021 Talks ⏩ https://percona.tv/PerconaLive2021
Monitor your Database For Free ⏩ https://percona.tv/pmm-yt
Kubernetes Operator for Databases ⏩https://per.co.na/kubernetes-operators

Connect With us on our Social Networks 👇👇👇
Follow Percona on Twitter: https://per.co.na/twitter
Follow Percona on Facebook: https://per.co.na/facebook
Follow Percona on Instagram: https://per.co.na/instagram
Follow Percona on LinkedIn: https://per.co.na/linkedin