MySQL Replication course from zero to hero | MySQL DBA

Learn MySQL Replication Master Slave and MySQL Database Administration in this course : make your MySQL DBA job easy

4.14 (202 reviews)
Udemy
platform
English
language
Databases
category
instructor
MySQL Replication course from zero to hero | MySQL DBA
1,455
students
7.5 hours
content
May 2022
last update
$64.99
regular price

What you will learn

MySQL Database Replication

MySQL Database Administration

MySQL Master slave Replication

MySQL High availability

Description

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.

Content

Introduction

Course Agenda
Replication introduction
Replication Architecture
Types of Topologies
lab about lab

How to use XtraBackup

Installing extrabackup
Taking Incremental backup and restoring using Percona XtraBackup

Configure Replication using different Methods

Configure Replication based on binlog file position part1 Slide
Configure Replication based on binlog file position part2 Practical
what does Show slave status means
Configure MySQL replication using xtrabackup8
Streaming MySQL Backups with Percona XtraBackup xbstream
Configure MySQL replica set using clone plugin

How to Repair MySQL Replication

Repair MySQL replication Intro
How Skip counter works on transactional table
How Skip counter works on Non-transactional table
How to use Pt-slave-restart to start replication

How to remove replication

How to remove replication

Make your replica consistent

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

GTID base Replication

Introduction to GTID
configure GTID replication

How to Repair GTID Replication

How to Solve Errors In GTID Replication and use pt-slave-restart
What is Errant GTID
How to Find and Fix Errant GTID
How to fix errant GTID by setting GTI_PURGED Values

Semi synchronous replication

Semi synchronous replication intro
How to setup semi synchronous replication.
How to disable Semi synchronous replication

Reviews

Fernando
October 21, 2023
Si es una buena elección pero hay que ir despacito y parando porque el instructor va un poco saltando de un lado para otro. Hay cosas que ya tiene realizadas y otras no. Podría estar algo más preparado mostrando cada paso.
Capacitaciones
October 12, 2023
Ha sido la mejor elección, porqué ha contribuido a enriquecer mis conocimientos sobre todo lo que converge a las DB's y las diferentes implementaciones de replica de datos.
Sander
October 2, 2023
Very chaotic overview of standard steps which are required to setup replication, Also steps in sources seem to be outdated which doesn't make it easy for starters, YouTube sources are easier
Sumit
July 28, 2023
- No clear flow of the course. - The slides and the content are as is repeated from the documentation rather than explaining what it means. - Will definitely help with someone who is very new to MySQL replication. - Should add content for reasons and resolution for Replication lag and improving replication performance. - Agenda listed ProxySQL but no section on it.
Paul
July 5, 2023
Although the content covered was as expected I do not think that the course flows very well. I also feel that some of the explanations are unclear and "jump around" topics.
Naumche
April 25, 2023
Lot's of unnecessary "OK", guys ,,, Not clear flow of the lectures, like target audience are High school students
Silaphet
February 28, 2023
Need to slow down everything. Need to speak slower, type slower and move cursor slower so that we can follow easily.
Phyo
November 27, 2022
It's really nice , I'm totally beginner but instructor taught clearly.I'm afraid that i can't follow the instruction well but now can follow the lecture very well. Thanks
Boedy
August 8, 2022
This is a very good course. The mentor have good understanding of the topics. Btw This course could be improved for some slides (Like GTID Life Cycle) by use annotation or visual pointer (like laser pointer in class presentation) while the mentor explaining something.
Sankalp
February 11, 2022
The course quality is poor. The instructor should take down the course and do a complete restructure. The instructor seems to lack teaching experience. There are many instances when the instructor is just not able to articulate the concepts clearly. The instructor has potential and can improve the course. May be collaborating with someone who is professional in the teaching field can improve the course. It is high time for Udemy to work with instructors and curate their course material, before publishing it. If you plan to take the course, please refer to the MySQL documentation regularly for concepts that you are not able to understand from this course.
Coleman
December 20, 2021
Talk, talk, talk... really could benefit from some visuals instead of just a single static bullet outline.
Sunil
November 21, 2021
Provided a detailed understanding about replication , however expected little more detailed about the topics
Karol
October 21, 2021
A very good course. The author has a working knowledge and helped me a lot in understanding the clustering layer in MySQL
Vladimir
September 13, 2021
Good technical content, the presenter has a very strong accent, and the audio sometimes get's really bad, manually created subtitles would help.
Gaurav
August 26, 2021
The instructor is not clear with what he is doing which creates confusion for all. The verbal communication is also not proper and explains everything is a hurry. No basic things are taught which is needed to give the clear idea why we are performing the task and practical. Could be much better for the freshers to learn from depth.

Charts

Price

MySQL Replication course from zero to hero | MySQL DBA - Price chart

Rating

MySQL Replication course from zero to hero | MySQL DBA - Ratings chart

Enrollment distribution

MySQL Replication course from zero to hero | MySQL DBA - Distribution chart
4180404
udemy ID
7/12/2021
course created date
8/1/2021
course indexed date
Bot
course submited by