Build Systems that Drive Business
30–31 Oct 2018: Training
31 Oct–2 Nov 2018: Tutorials & Conference
London, UK

Sharding a MySQL cluster using Vitess

Jitendra Vaidya (PlanetScale Inc.), Rafael Chacon (Slack)
13:15–13:55 Thursday, 1 November 2018
Distributed Data
 Location: Buckingham Room - Palace Suite
Secondary topics:  Resilient, Performant & Secure Distributed Systems
Average rating: ***..
(3.50, 2 ratings)

Prerequisite knowledge

  • A basic understanding of relational databases
  • Experience using or administering a relational database, such as MySQL

What you'll learn

  • Learn how to use Vitess, a database solution for deploying, scaling, and managing large clusters of MySQL instances

Description

Are you dealing with the challenges of rapid growth? Are you wondering how to scale your database layer? Should you use NoSQL? Should you shard your relational database? If you’re facing these kind of problems, this tutorial is for you.

Vitess is a database solution for deploying, scaling, and managing large clusters of MySQL instances. It’s architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware, and it combines and extends many important MySQL features with the scalability of a NoSQL database.

Jitendra Vaidya and Rafael Chacon demonstrate how to get a Vitess cluster up and running and how to perform most of the typical operations that you’ll face while running Vitess clusters in a production environment.

Topics include:

  • Vitess components: vttablets, vtgate, lock server, and vtctld
  • Setting up a cluster
  • Cluster usage with sharded tables
  • Planned failover
  • Unplanned failover with orchestrator
  • Workflows (splitting a shard)
Photo of Jitendra Vaidya

Jitendra Vaidya

PlanetScale Inc.

Jitendra Vaidya is cofounder and CEO at PlanetScale. Jiten has over 25 years of experience as a software engineer and manager. He was one of the first engineers to transfer from Google to YouTube, where he carried a pager and built stability and automation around MySQL. He also worked at Dropbox and the United States Digital Service (USDS). Jiten enjoys reading and hiking in his spare time.

Photo of Rafael Chacon

Rafael Chacon

Slack

Rafael Chacon is a senior software engineer on the infrastructure team at Slack, where he is working on the MySQL database layer on top of Vitess. Rafael is passionate about scaling and distributed systems. Previously, he was part of the core services team at MyFitnessPal, where he worked on the foundational services that helped scaled the application to more than 100 million users.