Becoming a Production MySQL DBA
What you'll 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.
Description
**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 **
MySQL Server Introduction
Why MySQL?
Meet Bob, The future DBA
MySQL Websites
MySQL Server Installation
Installing MySQL Server Community Edition
Installing MariaDB Database Server
Installing Percona MySQL Server
installing Specific MySQL Version
Removing MySQL
Exploring MySQL Server
MySQL Architecture
MySQL Installed File Locations
MySQL Executable Programs
MySQL Shell Commands
MySQL Socket File
MySQL Global & Session Variables
MySQL Remove vs Local Connections
MySQL User Administration
MySQL Accounts
Creating DBA Account WITH GRANT OPTION
MySQL Roles
Granting Permissions to Roles
Granting Roles to Users
MySQL Database Administration
Storing Auth Credentials using mysql_config_editor
MySQL Administrative Programs
mysqlimport, mysqlshow, mysqlcheck utilities
Loading Time Zone Data
Downloading Example Databases
MySQL Server Configuration
MySQL Default Option Files
Adding Option Files
Option File Inclusions
MySQL Error Log
MySQL Binary Log Files
Relocating InnoDB System Tablespaces
Moving Redo Log Files
Upgrading MySQL Server
Performing MySQL Minor Version Upgrade
Performing MySQL Major Version Upgrade
Running Pre-Upgrade Checks
Version Comparison Between Primary & Replica
MySQL Replication
Performing Traditional Position-Based Relication
Performing GTID Replication
Ignoring Databases for Replication
Excluding Tables from Replication
MySQL Storage Engines
BLACKHOLE
MEMORY
INNODB
CSV
MySQL InnoDB Storage Engine Configuration
InnoDB Architecture
Memory-Based Architecture
InnoDB Buffer Pool
Dedicated Server
Doublewrite Buffer
System Tablespaces
MySQL Backup & Restore
Performing Hot Backup
Performing Cold Backup
Performing Logical Backups
Restoring from Hot/Cold Backups
Running MySQL on Docker
Installing Docker Engine
Pulling MySQL Image
Running MySQL Container
DBA Tips & Tricks Club
Customizing MySQL Prompt
** January 2023 - Course Update **
SECTION: Running MySQL on Docker
Lessons Added:
Converting MySQL Instance to Container
Installing MySQL Server on Docker Host
Demo - Attach Container to Instance
** Feburary 2023 - Course Update **
NEW SECTION: Cloud Database Administration
Lessons Added:
Cloud Database Lab Setup
Creating Droplets on DigitalOcean
Disabling SELINUX
GTID Based Replication Setup
Online Data Duplication using xbstream
Setting up AWS Cloud Replica
NEW SECTION: Database Scripting
Lessons Added:
Introduction to Shell Scripting
Shell Script Permissions
Bash Shell Shebang
Mixing Text with Shell Commands
Shell Script Arguments
Shell Variables
Output of Command as Variable
For Loop in Shell Scripting
Assignment: Create Shell Sript to Create MySQL Accounts
Assignment: Create Shell Script to Download Example Database
Assignment: Create Shell Script to Create tables in specific databases
Introduction to Percona Toolkit
Installing Percona Toolkit
pt-mysql-summary
pt-summary
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...
Who this course is for:
- 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.
Instructor
- 4.6 Instructor Rating
- 954 Reviews
- 11,242 Students
- 4 Courses
I'm Abid Malik, a Senior Database Administrator with over 15 years of experience in database administration, infrastructure solutions, cloud migrations, and providing 24X7 production support.
I have worked in some of the top companies in the United States like Verizon, ChannelAdvisor, Cengage Learning. I am passionate about learning new technology and teaching.
I have extensive experience in MySQL, MongoDB and supporting them on AWS Cloud.