I dont see anything unusual or missing on your config file and as the only thing missing are deletes, i think that might be a permission issue.

Can you check out the grants for your replication users and see if they have full permissions granted ?

mysql> show grants for xxxxx;

where is xxxxx is replication and replication2 respectively.

Carlos


On 1/18/2010 1:35 AM, Manasi Save wrote:
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 Save



Quoting Anand kumar :

    can you give us the configuration(.cnf) file from both the masters ?
    --Anand
    On Sat, Jan 16, 2010 at 3:06 PM, Manasi Save
    <manasi.s...@artificialmachines.com
    <mailto: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



Reply via email to