1. Settings to be done in Master DB server:
Edit my.cnf file (/etc/my.cnf) and enter the following:
server-id = 1
log-bin
2. Login to mysql DB in master server and run the following command:
mysql> show master status;
Continue reading ‘Setting up MySQL replication’