Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

The Database Designer's Modern-Day Cookbook

The Database Designer's Modern-Day Cookbook

 25 April - 11:30 AM - 12:20 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Developer
Topics:
MySQL

Description

I’ve been learning about database internals by learning the theory, seeing how other systems have implemented ideas, and trying to implement them myself. Of course, it’s not always easy, and I’m not making anything that compares to the scale of something like MySQL or MongoDB, but reinventing a few small wheels here and there has given me a better understanding of how bigger systems work. I’ll talk about how some fundamental design choices regarding immutability, transactions, and ACID lead to some interesting trade-offs and implementation differences. I’ll also talk about replication, and how it can be as simple as sending the same queries to multiple servers or how stronger guarantees can lead systems to use more complicated approaches like synchronous replication and consensus.

Speakers

Preetam Jinka's picture

Preetam Jinka

Engineer, VividCortex

Biography:

Preetam is an engineer at VividCortex where he works on anomaly detection and back-end systems.

Share this talk