MariaDB - proper Slave/Master replication switching

DBA Docs - https://ruslan-potomka.github.io/short-docs/

This video shows how to correctly switch replication step by step so that the old master becomes a replica, and the old replica becomes the master.

0:00 Start
2:02 Block all operations on the current Primary server
2:36 We compare the positions of binary catches on the Primary and Slave servers
3:13 Stopping the database on the old Primary
3:53 On the old Primary, enable read mode so that no one accidentally starts writing data to the database
4:25 On the old Slave database, we stop replication and reset connections to the old master
4:58 We launch the database on the old Primary and reset its binary logs
5:47 On the new Primary database, we reset the binary logs and look at the current position in the new log
6:40 We connect the former Primary to the new Primary database and start replication
8:42 On the new Primary we remove the reading mode
10:36 The end

#mariadb #master #slave #primary #standby #database #db #replication #switching

Видео MariaDB - proper Slave/Master replication switching канала TECHWIKI