Becoming a Production MySQL DBA

• 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

**Disclaimer**

For the section Running MySQL on Docker, This course requires you to download Docker Desktop If you are a Udemy Business user, please check with your employer before downloading software.

**Course Overview **

Welcome to this amazing course on MySQLServer 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 MySQLServer

   4. installing Specific MySQL Version

   5. Removing MySQL

   6. 
      

3. Exploring MySQL Server

   1. MySQL Architecture

   2. MySQL Installed File Locations

   3. MySQLExecutable Programs

   4. MySQL Shell Commands

   5. MySQLSocket File

   6. MySQLGlobal &Session Variables

   7. MySQLRemove vs Local Connections

4. MySQL User Administration

   1. MySQL Accounts

   2. Creating DBA Account WITHGRANTOPTION

   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. MySQLDefault 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 GTIDReplication

   3. Ignoring Databases for Replication

   4. Excluding Tables from Replication

9. MySQLStorage 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

14. MySQL Database Objects

    1. Views

    2. Stored Procedures

    3. Functions

    4. Triggers

    5. Events

** 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

NEW SECTION: MySQLDatabase Objects

Lesson Added:

1. Section Introduction

COURSE UPDATES:

* DBA interview questions are added for section 2

* DBA interview questions are added for section 3

We will be adding more content to this course soon...