Hi Manasi, That alone is the difference in this case. -- Thanks Suresh Kuna MySQL DBA
On Tue, Jan 19, 2010 at 10:36 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Dear Carlos, > > Thanks for the response. But I haven't gave any privileges besides > repl_slave priv to user replication and replication2 respectively. > So does that amke any difference really? > > > Thanks in advance. > -- > Regards, > Manasi Save > > Quoting Carlos Proal <carlos.pr...@gmail.com>: > >> >> 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 >> > >> > >> >> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > >