Becoming a Production MySQL DBA

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

Ratings: 4.42 / 5.00




Description

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


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


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

What You Will 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

Who Should Attend!

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