MySQL – Master slave replication setup
to setup master – slave
ON MASTER SERVER
STEP #1 – set server ID
edit my.cnf and add
server-id=1
STEP #2 – Create slave user
mysql grant replication slave on *.* to ‘slave_username’@192.168.16.5 \ identified by ‘slave-password’;
STEP #3 – restart Mysql
service mysqld restart
ON SLAVE SERVER
STEP #4- Edit my.cnf file and add
server-id = 10
master-host = 192.168.1.1
master-user = slave_username
master-password = slave-password
replicate-ignore-db=mysql
replicate-wild-do-table=mydb.%
STEP #5 – set master host
#mysql -uroot -p
mysql > slave stop; change master to master_host = ‘MASTER_IP’, master_user = ‘USERNAME’, master_password = ‘PASSWORD’ ;
STEP #6 – restart Mysql
Service mysqld restart
STEP #7 – slave start
slave start;
STEP #8 – check status
mysql: show slave status\G