32 - MySQL replication Introduction | Master Slave #Replication #MySQL​ DBA Tutorial | MySQL 8

preview_player
Показать описание
Check my course on mysql replication

What is MySQL Replication?
replication enables data from one MySQL server (the master) to be replicated to one or more MySQL servers (the slaves). MySQL Replication is very easy to set up and is used to scale out read workloads, provide high availability and geographic redundancy, and offload backups and analytic jobs
Replication Scheme:
• Asynchronous replication
• Semi-synchronous replication
Global Transaction Identifier (GTID)
Replication in MySQL 5.5 and Earlier
How GTID Solves the Problem
Multi-Threaded Slave
Crash-Safe Slave
Group Commit

Please Follow me on Social Media
Рекомендации по теме
Комментарии
Автор

nice but font is small so please increase font size in practice

pawankunal
Автор

what will be the procedure if we want replication between 2 master and 1 slave ?

RohitSingh-ekcl
Автор

good work bhai but yehi videos agr aap urdu me bhi daldo to sab smjh ajayega

Hassankhan-zrup
Автор

We need some more information about what are the changes in 5.8

sunilreddy
Автор

Very good tutorial.thanks for making this video's.

Can you share how to monitor the dB replication using tool's?

pandiselvi
Автор

show some practical with mysql on different vm

vishalsaxena
visit shbcf.ru