MySql

Switchover MySQL   Source 199Replica 198 SOURCE SET GLOBAL read_only=ON; set global super_read_only=ON; show variables like '%super%read%'; show variables like '%read_only%'; flush tables;flush logs; SHOW MASTER STATUS; REPLICA stop slave; …

Restarting MYSQL Instances and Servers   Environment:- MySQL Database Instances running in two separate Windows Servers namely PROD (172.21.50.162) and DR (10.218.86.8). They have been setup as Source (PROD) and …

Configuration of MYSQL Master – Slave Replication   Environment:- Two Server’s with MYSQL database and different hosts/nodes, Master (172.21.50.162) and Slave (10.218.86.8). Replication will be configured between these two servers …