Becoming a Production MySQL DBA

About Becoming a Production MySQL DBA

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

: MySQL Database 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...