Becoming a Production MySQL DBA

******* Course Overview *******

Welcome to this amazing course on MySQL Server Administration. You will learn all aspects of MySQL Server including setting it up, managing it, troubleshooting it. You will learn how to upgrade MySQL, how to setup replication, how to migrate to AWS cloud, and much more!

******* Course Contents *******

1. MySQL Server Introduction

   1. Why MySQL?

   2. Meet Bob, The future DBA

   3. MySQL Websites

2. MySQL Server Installation

   1. Installing MySQL Server Community Edition

   2. Installing MariaDB Database Server

   3. Installing Percona MySQL Server

   4. installing Specific MySQL Version

   5. Removing MySQL

   6. 
      

3. Exploring MySQL Server

   1. MySQL Architecture

   2. MySQL Installed File Locations

   3. MySQL Executable Programs

   4. MySQL Shell Commands

   5. MySQL Socket File

   6. MySQL Global & Session Variables

   7. MySQL Remove vs Local Connections

4. MySQL User Administration

   1. MySQL Accounts

   2. Creating DBA Account WITH GRANT OPTION

   3. MySQL Roles

   4. Granting Permissions to Roles

   5. Granting Roles to Users

5. MySQL Database Administration

   1. Storing Auth Credentials using mysql_config_editor

   2. MySQL Administrative Programs

   3. mysqlimport, mysqlshow, mysqlcheck utilities

   4. Loading Time Zone Data

   5. Downloading Example Databases

6. MySQL Server Configuration

   1. MySQL Default Option Files

   2. Adding Option Files

   3. Option File Inclusions

   4. MySQL Error Log

   5. MySQL Binary Log Files

   6. Relocating InnoDB System Tablespaces

   7. Moving Redo Log Files

7. Upgrading MySQL Server

   1. Performing MySQL Minor Version Upgrade

   2. Performing MySQL Major Version Upgrade

   3. Running Pre-Upgrade Checks

   4. Version Comparison Between Primary & Replica

8. MySQL Replication

   1. Performing Traditional Position-Based Relication

   2. Performing GTID Replication

   3. Ignoring Databases for Replication

   4. Excluding Tables from Replication

9. MySQL Storage Engines

   1. BLACKHOLE 

   2. MEMORY

   3. INNODB

   4. CSV

10. MySQL InnoDB Storage Engine Configuration

    1. InnoDB Architecture

    2. Memory-Based Architecture

    3. InnoDB Buffer Pool

    4. Dedicated Server

    5. Doublewrite Buffer

    6. System Tablespaces

11. MySQL Backup & Restore

    1. Performing Hot Backup

    2. Performing Cold Backup

    3. Performing Logical Backups

    4. Restoring from Hot/Cold Backups

12. Running MySQL on Docker

    1. Installing Docker Engine

    2. Pulling MySQL Image

    3. Running MySQL Container

13. DBA Tips & Tricks Club

    1. Customizing MySQL Prompt

******* January 2023 - Course Update *******

SECTION: Running MySQL on Docker

Lessons Added:

1. Converting MySQL Instance to Container

2. Installing MySQL Server on Docker Host

3. Demo - Attach Container to Instance

******* Feburary 2023 - Course Update *******

NEW SECTION: Cloud Database Administration

Lessons Added:

1. Cloud Database Lab Setup

2. Creating Droplets on DigitalOcean

3. Disabling SELINUX

4. GTID Based Replication Setup

5. Online Data Duplication using xbstream

6. Setting up AWS Cloud Replica

NEW SECTION: Database Scripting

Lessons Added:

1. Introduction to Shell Scripting

2. Shell Script Permissions

3. Bash Shell Shebang

4. Mixing Text with Shell Commands

5. Shell Script Arguments

6. Shell Variables

7. Output of Command as Variable

8. For Loop in Shell Scripting

9. Assignment: Create Shell Sript to Create MySQL Accounts

10. Assignment: Create Shell Script to Download Example Database

11. Assignment: Create Shell Script to Create tables in specific databases

12. Introduction to Percona Toolkit

13. Installing Percona Toolkit

14. pt-mysql-summary

15. pt-summary