Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

PostgreSQL to MySQL: A DBA Perspective

PostgreSQL to MySQL: A DBA Perspective

 26 April - 1:00 PM - 1:50 PM @ Ballroom G
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Operations
Wildcard
Topics:
Devops
Tools and Techniques
MySQL

Description

Come on a journey with Patrick as he walks you through his transformation from a PostgreSQL DBA to a MySQL DBA. This talk will be a story of Patrick's journey where we'll walk through some of the major differences between PostgreSQL and MySQL and how we use both of them at Yelp. We'll talk about query plans and the query optimizer, index types and their structure, and the issues around schema changes; highlighting some fundamental differences between these two great database products. This talk will be useful to both MySQL and PostgreSQL DBAs, allowing them to understand better each other's background, by giving perspective on the benefits and drawbacks of each database.

Speakers

Patrick King's picture

Patrick King

Database Administrator, Yelp

Biography:

Patrick King is a Database Administrator at Yelp, where he spends his time wrangling MySQL, rewriting his .vimrc, guiding servers through existential crises, and performing sacrifices to the AWS networking layer. Patrick is an experienced PostgreSQL DBA and has recently started with MySQL, loving every experience with it. Outside of work, he is a triathlete, Ikea furniture enthusiast, and proud cat dad. You can find him on Twitter (@mr_mustash) ranting about Jenkins, listening to Vaporwave, and posting too many photos of his cats.

Share this talk