Becoming a Production MySQL DBA

An awesome journey towards world's most popular open source database to become a Production MySQL DBA.

Created by: Abid Malik | DevOps & Cloud Automation
Databases, DevOps, and Cloud Automation

What Will I Learn?

• You will learn how to install latest version of MySQL Server including MariaDB and Percona Server for MySQL.
• You will learn how to secure the installation of MySQL and how to start/stop/restart MySQL service using systemd.
• You will learn how to customize MySQL server configuration, how to store InnoDB log files, binary log files, MySQL server log files in separate locations.
• You will learn how to connect to MySQL locally as well as remotely and how to perform database administration.
• You will learn how to perform minor and major MySQL upgrades, how to install new components and remove plugins.
• You will learn how to setup GTID-based master-slave replication, and how to setup filtered replication.
• You will learn how to take logical as well as physical backup, how to restore MySQL backups, how to setup a new slave from backup.
• You will learn how to troubleshoot MySQL server issues.
• You will learn how to run MySQL in Docker

Requirements

• You must have basic understanding of MySQL or any RDBMS
• You must know the basics of linux operating system.

Target audience

• Junior MySQL DBAs looking to improve and advance their DBA skills.
• Anyone interested to jump start their career as a Database Administrator.
• System Administrators looking to learn Database Administration skills.