MySQL Replication course from zero to hero | MySQL DBA

What you will learn in this course.

Some Great Skil requires for MySQL Database administration

Introduction to Replication and Different type of topologies.

• Master-Slave

• Master and Multi slave

• Master-Master Replication

How to add filters in Replication, ignore tables, or database.

Configure replication (mysqldump,extrabackup,xbstream,Mydumper,clone plugin).

How to install Percona Xtrabackup

How to take backup using Extrabackup

• How to take a full backup,

• how to take incremental backup.

• how to restore the full backup and apply incremental backup.

Difference btw GTID/traditional log position-based replication.

Configure Semi-syn replication.

Configuring the Slave-delay.

Type of binary log formats.

• row base

• statement base

• mix mode

Failure scenarios of Mysql, how to sync replication.

How to use pt-slave-restart.

How to solve errors, errant GTID on the slave.

• Checking what is the error.

• Duplicate user error, Duplicate key error.

• How to skip those errors

• How to find if there is Errant GTID.

• how to identify the errant GTID.

How you can read the Binary Logs.

How to check Replication consistency.

How to use pt-table-checksum and pt-table-sync.

Install Percona Monitoring and Management

How to configure Multi Thread Slave.

• Checking if Workers are Replicating fine.

• What is the limitation of MTS?

• Creating views for easy monitoring of the MTS.

Configure Orchestrator for Failover.

NOTE: Below Lectures are Pending Please wait for it I am working on them coming soon :) 

• How to do graceful failover with Orachestaror.

• How to solve errant GTID with Orchestrator.

Configure ProxySQL for the load balancer.

• How to split read and write using ProxySQL.

• Testing the Node failure and load balancing with ProxySQL.