MySQL Replication Delete is not gettting replicated

--=_6csujyvoidfk
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


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


--=_6csujyvoidfk
Content-Type: multipart/related;
boundary="=_6foutq37xke8";
start="6fpr2ywudr40@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_6foutq37xke8
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 6fpr2ywudr40@mail.artificialmachines.com

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,

Re: MySQL Replication Delete is not gettting replicated

--=_4a9wt6cbwojk
Content-Type: text/plain;
charset=UTF-8;
format="flowed"
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

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.s ockold_passwords=1
log-bin=/usr/local/mysql/bin.log#binlog-do-db= # input the
database which should be replicatedbinlog-ignore-db=mysql #
input the database that should be ignored for
replicationbinlog-ignore-db=testlog-bin-index=/usr/local/mys ql/log-bin.indexlog_slave_updates
server-id=2
auto_increment_increment=2auto_increment_offset=1
#information for becoming slave.master-host = 192.168.1.1master-user =
replicationmaster-password = replicationmaster-port = 3306
[mysql.server]user=mysql
[mysqld_safe]err-log=/var/lib/mysql/mysql.logpid-file=/var/l ib/mysql/mysql.privatedns.com.pid
ON MASTER 2:
[mysqld]datadir=/var/lib/mysql/socket=/var/lib/mysql/mysql.s ockold_passwords=1
log-bin=/usr/local/mysql/bin.log#binlog-do-db= # input the
database which should be replicatedbinlog-ignore-db=mysql #
input the database that should be ignored for
replicationbinlog-ignore-db=testlog-bin-index=/usr/local/mys ql/log-bin.indexlog_slave_updates
server-id=1
auto_increment_increment=2auto_increment_offset=2
#information for becoming slave.master-host = 192.168.1.2master-user =
replication2master-password = replication2master-port = 3306
[mysql.server]user=mysql
[mysqld_safe]err-log=/var/var/lib/mysql/mysql.logpid-file=/v ar/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 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



--=_4a9wt6cbwojk
Content-Type: multipart/related;
boundary="=_4mj6eh4iwakg";
start="4mjtsp3utshs@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_4mj6eh4iwakg
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 4mjtsp3utshs@mail.artificialmachines.com

--

Regards,

Re: MySQL Replication Delete is not gettting replicated

--------------020601040609080501050005
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


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= # 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= # 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
> > > 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
>
>


--------------020601040609080501050005--

Re: MySQL Replication Delete is not gettting replicated

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 :
>
> 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= # 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= # 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
> > > > > 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=gcdmg-mysql-2@m.gmane.org

Re: MySQL Replication Delete is not gettting replicated

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 to figure out whats wrong.

Carlos

On 1/18/2010 11:06 PM, Manasi Save 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 :
>>
>> 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= # 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= # 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
>> > >> > > 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=gcdmg-mysql-2@m.gmane.org

Re: MySQL Replication Delete is not gettting replicated

--00504502cc1803a719047d7df5d9
Content-Type: text/plain; charset=ISO-8859-1

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.save@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 :
>
>>
>> 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= # 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= # 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
>> > >> > > 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=sureshkumarilu@gmail.com
>
>

--00504502cc1803a719047d7df5d9--