Procedure for making Salve server as Master for Radico Environment
Appearance
Procedure for making Slave server as Master for Radico Environment[edit]
- Ensure the Current Master Server is Down and should not come up with its own original IP
- Go to slave Server
- change /etc/my.cnf for event_scheduler=off to event_scheduler=on OR Comment Line event_scheduler=off and UN-Comment event_scheduler=on . Save the file
- Change the IP of Slave Server to IP of Master Server . Edit via GUI.
- Stop Slave on the slave server via CLI . Run " mysql -proot -e 'slave stop' " .
- Now Restart the Mysql Server via service mysqld restart
- Check at the application End .
Caution : The Original Master server should not have the same IP . Now old Master server needs to be made replica by following the Replication process.