Rootconf 2019

On infrastructure security, DevOps and distributed systems.

OLTP or OLAP? Why not both?

Submitted by Jiten Vaidya (@jvaidya) on May 6, 2019

Section: Full talk Technical level: Intermediate Session type: Demo Status: Confirmed & scheduled

Abstract

vitess.io is an open source sharding middleware system that runs massive OLTP workloads at companies susch as Youtube, Slack and Square. Vitess recently added support for cross-shard materialized views and near real-time rollups - traditionally considered to be OLAP features. The underlying feature that enables this is “VReplication” - the ability to parse MySQL binary log and use it to enable interesting use-cases. I will explain the architecture of Vitess, the genesis of Vreplication for resharding databases and demonstrate VReplication in action for cross-shard materialized views and roll-ups.

Outline

  • Vitess history
  • Vitess architecture
  • Vitess resharding and demo
  • VReplication explained
  • VReplication demo

Requirements

Laptop with an internet connection.

Speaker bio

Jiten Vaidya is the co-founder and CEO at PlanetScale. Prior to starting PlanetScale, Jiten held various backend and infrastructure roles at US Digital Service, Dropbox, Youtube and Google. At Youtube, he managed the teams that operated Youtube’s MySQL databases at massive scale using the open source software, vitess.io.

Comments

{{ gettext('Login to leave a comment') }}

{{ gettext('You need to be a participant to comment.') }}

{{ formTitle }}
{{ gettext('Post a comment...') }}
{{ gettext('New comment') }}

{{ errorMsg }}