Airtable - Migrating a Multitenant Architecture to MySQL 8.0

Update: 2023-03-24

Description

The storage team at Airtable published a blog post describing, in detail, the migration of their petabyte-scale storage layer from MySQL 5.6 to MySQL 8.0.

Andrew Wang, the lead of Airtable's storage team, joined us to discuss the migration, Airtable's storage architecture, data isolation levels, engineering culture, and more.

The blog: https://medium.com/airtable-eng/migrating-airtable-to-mysql-8-0-809f0398a493

Github's gh-ost, recommended by Andrew: https://github.com/github/gh-ost

Andrew's LinkedIn (he's hiring): https://www.linkedin.com/in/aawang/

Comments

In Channel

Optimizing Cloud Costs for SaaS Startups

2024-04-0429:35

SaaS: More than just a business model

2024-01-2952:04

Building Streaming on S3

2024-01-0358:11

Kora: Cloud Native Platform for Kafka

2023-11-2742:49

Cell Based Architecture for Early Stage SaaS

2023-11-1655:12

Building a Serverless Streaming Platform

2023-11-1342:23

Never Rewrite! And other advice for SaaS Developers

2023-08-3136:31

The Wonders of Postgres Logical Decoding Messages

2023-08-2840:38

Postgres, Performance and Rails

2023-08-2357:58

Trends in Observability and Alerting

2023-08-2136:44

Cloudflare: Performance isolation in multi-tenant DB

2023-08-1736:14

Real-time Data Infrastructure - At Uber and Beyond

2023-08-1438:10

Scalable Multi-tenant Platforms at Loom and at Times

2023-08-1047:03

Building SaaS on Kafka Streams

2023-08-0753:48

Transaction Isolation - Demystified!

2023-08-0331:11

Giving and Receiving Actually Useful Advice

2023-07-3117:16

The Promise of Serverless

2023-07-2801:06:30

Airtable - Migrating a Multitenant Architecture to MySQL 8.0

2023-03-2438:34

The Multitenant journey - From 0 to 500M ARR

2023-02-2855:16

Compute-Storage Separation Explained

2023-01-1318:01

00:00

Airtable - Migrating a Multitenant Architecture to MySQL 8.0

#box-pro-ellipsis-176056183160182{-webkit-line-clamp:2;}Airtable - Migrating a Multitenant Architecture to MySQL 8.0

Airtable - Migrating a Multitenant Architecture to MySQL 8.0

Gwen

Airtable - Migrating a Multitenant Architecture to MySQL 8.0