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 x;
where is
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
Hi Manasi
Yes, you only need the repl_slave_priv, the show grants should give you
something like:
GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%' IDENTIFIED BY
PASSWORD '...'
If thats ok, have check your binlog and relay binlog to see if them
contain the delete statements?
Im trying
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
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.sockold_passwords=1log-bin=/usr/local/mysql/bin.log#binlog-do-db=database
name # input the database which should be
replicatedbinlog-ignore-db=mysql
#
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