Hi Anand,
Please find below my configuration
file of both the masters:
ON MASTER 1:
[mysqld]
datadir=/var/lib/mysql/
socket=/var/lib/mysql/mysql.sock
old_passwords=1
log-bin=/usr/local/mysql/bin.log
#binlog-do-db=<database
name> # input the database which should be
replicated
binlog-ignore-db=mysql
# input the database that should be ignored for
replication
binlog-ignore-db=test
log-bin-index=/usr/local/mysql/log-bin.index
log_slave_updates
server-id=2
auto_increment_increment=2
auto_increment_offset=1
#information for becoming slave.
master-host =
192.168.1.1
master-user = replication
master-password =
replication
master-port = 3306
[mysql.server]
user=mysql
[mysqld_safe]
err-log=/var/lib/mysql/mysql.log
pid-file=/var/lib/mysql/mysql.privatedns.com.pid
ON MASTER 2:
[mysqld]
datadir=/var/lib/mysql/
socket=/var/lib/mysql/mysql.sock
old_passwords=1
log-bin=/usr/local/mysql/bin.log
#binlog-do-db=<database
name> # input the database which should be
replicated
binlog-ignore-db=mysql
# input the database that should be ignored for
replication
binlog-ignore-db=test
log-bin-index=/usr/local/mysql/log-bin.index
log_slave_updates
server-id=1
auto_increment_increment=2
auto_increment_offset=2
#information for becoming slave.
master-host =
192.168.1.2
master-user = replication2
master-password =
replication2
master-port = 3306
[mysql.server]
user=mysql
[mysqld_safe]
err-log=/var/var/lib/mysql/mysql.log
pid-file=/var/lib/mysql/mysql.privatedns.com.pid
Please let me know if I need to add any parameter to enable
this replication.
Thanks in advance.
--
Regards,
Manasi SaveQuoting Anand kumar
can you give us the configuration(.cnf) file from both the masters ?--AnandOn Sat, Jan 16, 2010 at 3:06 PM, Manasi Save <manasi.s...@artificialmachines.com> wrote:
Hi All,
I have configured MySQL Master-Master Replication on my servers. When I am inserting or updating any data in a regular table the data is getting replicated.
But When I am doing delete on that same table. the data is only getting deleted only on the server where I am doing delete. but it is not getting replicated on its slave.
Even if I am doing truncate it is not getting replicated. Can anyone provide any input on this?
Thanks in advance.
--
Regards,
Manasi Save
