Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Suresh Kuna 
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 :
>
>>
>> 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 x 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=sureshkumar...@gmail.com
>
>

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Carlos Proal 

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 x;

where is x 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=arch...@jab.org

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Manasi Save 

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 x;

where is x 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=arch...@jab.org

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread 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 x;

where is x 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
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-17 Thread Manasi Save 
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=      # 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/mysql/log-bin.indexlog_slave_updatesserver-id=2auto_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/lib/mysql/mysql.privatedns.com.pidON MASTER 2:[mysqld]datadir=/var/lib/mysql/socket=/var/lib/mysql/mysql.sockold_passwords=1log-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/mysql/log-bin.indexlog_slave_updatesserver-id=1auto_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=/var/lib/mysql/mysql.privatedns.com.pidPlease 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 Replication Delete is not gettting replicated

2010-01-16 Thread Manasi Save 
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