PostgreSQL to MySQL: A DBA Perspective
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.
Database Administrator, Yelp
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.