Monthly Archive for December, 2011

Setting up MySQL replication

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’