Open source relational databases like MySQL and PostgreSQL power some of the world's largest websites, including Yelp. They can be used out of the box with few adjustments and rarely require a dedicated database administrator for the first few months or even years. This means that System Administrators and Site Reliability Engineers are usually the first to respond to some of the more "interesting" issues that can arise as you scale your databases. This tutorial will cover MySQL, but many of the concepts apply to PostgreSQL and other open source RDBMS's. We'll first go over a broad set of DBA basics to introduce MySQL Database Administration and next cover the InnoDB storage engine, database defense and monitoring. Finally, I'll cover the wide array of online resources, books, open source toolkits, and scripts from MySQL, Percona, and the Open Source community that will make the job easier.
Sysadmins and SREs of all levels who have an interest or need to learn MySQL or supporting an open source relational database.
Sysadmins and SREs who join us for this tutorial will come away with a real-world and ready for production understanding of why and how MySQL works the way it does.
- MySQL Installation and Configuration
- Architecture and Filesystem Layout
- InnoDB Tuning and Optimization
- Transactions
- Replication and Scaling Out
- Schema/Query Basics, Indexes, and Query Plans
- Deciphering Common Errors
- Monitoring
- Backup and Restore
- Troubleshooting
- Online Communities
- Open Source Toolkits