Jump to content

Procedure for making Salve server as Master for Radico Environment

From TetraWiki
Revision as of 03:11, 11 August 2019 by Biswajit (talk | contribs) (Created page with "category:Radico-Khaitan == Procedure for making Salve server as Master for Radico Environment == * Ensure the Current Master Server is Down and should not come up with ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Procedure for making Salve server as Master for Radico Environment

  • 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.