MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Slave has more data than Master?
Posted by: Irfan Ali
Date: February 22, 2012 02:49AM

>> some data do not insert to the Master successfully, but relevant logs have been written successfully into binary logs.

No, Only successful events are written on master binary logs.

Do you have set slave as read_only in my.cnf ? Might be from app data directly inserted on slave ?

Do you have only inserts on master or delete queries also ?

Post my.cnf master / slave configuration parameters to check more.

Also check you shouldn't have any database user on slave with any DML operation privilege on slave database server.

For table checksum and diff. check for pt-table-checksum.

http://www.percona.com/doc/percona-toolkit/2.0/pt-table-checksum.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slave has more data than Master?
2475
Yang Jie
February 21, 2012 06:43AM
Re: Slave has more data than Master?
1206
Irfan Ali
February 22, 2012 02:49AM
Re: Slave has more data than Master?
1263
Yang Jie
February 22, 2012 10:23PM
Re: Slave has more data than Master?
1396
Irfan Ali
February 23, 2012 06:01AM
Re: Slave has more data than Master?
1057
Yang Jie
February 24, 2012 04:27AM
Re: Slave has more data than Master?
1161
Rick James
February 24, 2012 07:26AM
Re: Slave has more data than Master?
1123
Yang Jie
March 05, 2012 04:38AM
Re: Slave has more data than Master?
855
Yang Jie
March 22, 2012 05:26AM
Re: Slave has more data than Master?
790
Rick James
March 23, 2012 08:03PM
Re: Slave has more data than Master?
960
Yang Jie
March 26, 2012 02:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.