MySQL Worst Practices: Bring Your System to Its Knees

Wednesday 4:30PM-4:55PM

@ Swift Suite 1

MySQL / MariaDBOpen Source Databases

25 minutes conference

Beginner

Tracks:
Developer

We all know those conference talks that bleat on about doing the right thing at the right time. This talk aims to reveal some of the anti-best practices to illustrate how some installations of MySQL are doomed from day 0. Infrastructure choice, queries and everything in between deserve special attention if you really want to fail fast.

This talk will cover:
- Picking the worst hardware you can for your mission critical database
- Schema over-engineering
- Query disasters
- Split brain scenarios we all want to see
- Replication disaster zone
- Highly available fails
- Accumulate these tips for instant dismissal


Speakers

Andrew Moore

Andrew Moore (Digital Ocean)

MySQL Practice Manager

Biography:

Andrew has spent nearly a decade amongst the MySQL ecosystem witnessing events such as the Oracle acquisition, the meagre threat of NoSQL and the rise of heterogeneous database infrastructure. All of which made little more than a minor scratch in the armour of the worlds most popular RDBMS. Today, Andrew stands shoulder to shoulder with Percona's finest whilst they battle their way through the trials of schema changes, the mysteries of deadlocks and the ultimate goal of 100% data availability. Andrew is a seasoned speaker at MySQL events and co organiser of the MySQL meetup in the South West of England


Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA