filmov
tv
Check out MySQL Replication course on udemy #MySQL #Replication
Показать описание
Udemy Link
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.
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.