Download - An introduction to MySQL
Who Am I?GitHub: mcapanema
LinkedIn: https://br.linkedin.com/in/mcapanema
BankFacil (We are Hiring!)
Murilo Capanema - 2015
Agenda
4 Some MySQL basics
4 MySQL Environment
4 MySQL Storage Engines
4 MySQL Replication
4 MySQL Alternatives
4 BonusMurilo Capanema - 2015
Some MySQL basics
4 Use the standard paths
4 Separate the writing of the data from the OS
4 Enable logs
4 Monitor it
4 Have a backup strategy
4 Take real a good care of your indexes and schemaMurilo Capanema - 2015
MySQL Environment
4 Check your network tunings
4 Check your CPU tunings
4 Check your disk tunings
4 Check your database configuration
Murilo Capanema - 2015
Further Reading4 The MySQL “swap insanity” problem and the effects of the NUMA architecture
4 Understanding How MySQL Works by Understanding Metadata part I
4 Understanding How MySQL Works by Understanding Metadata part II
Murilo Capanema - 2015