03 Replication architecture

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
Рекомендации по теме
Комментарии
Автор

Hi thanks for the video,
i have a question about the replication.
If the master go down and the slave contuning get updated, what should happen if i put back the master in place ?

samirkonate
Автор

Super bro, please explain the reguler trouble shoots in replication

salmankhanpathan