Master-Master Replicaation in Mysql without restart the my sql server.

[Ligory Muthusamy]

Hi,

Master - Master Replication in Mysql , without restarting server in windows. Is it Possible.?. I tried make the master- Master Replication. When I added the new master then I needed to restart the server. Then only, master got reflected. So, can you any one give some light?. I am following below steps.


I) Configuration settings on Master. Say your master server is configured with 192.168.206.1 as IPAddress.

1) Install MYSQL Server

2) open my.ini file and append below lines at the bottom of the file

[mysqld]
log-bin=mysql-bin
server-id=1

3) restart the MYSQL server from services :- run -> services.msc

4) run below commands at mysql command prompt.

mysql> GRANT REPLICATION SLAVE ON *.* TO 'root'@'192.168.206.1';

mysql> FLUSH TABLES WITH READ LOCK;

mysql > SHOW MASTER STATUS;

Note1 : make a note of File and Position values, these values needs to be supplied during slave configuration.

mysql> UNLOCK TABLES;



On Master
---------
mysql> create database db1;
mysql> use db1;
mysql> create table temp_table( empname varchar(100));
mysql> insert into temp_table values ('testing');
mysql> select * from temp_table;


This steps, i followed. but unable to get reflection without restart the mysql server.

Thanks
Ligory



Edited 1 time(s). Last edit at 03/02/2013 11:33AM by Ligory Muthusamy.