MySQL Forums :: Replication :: Slave has more data than Master?
Slave has more data than Master?
Posted by: Yang Jie ()
Date: February 21, 2012 06:43AM
Hi all,
I have one Master and one Slave, tables are MyISAM in them. there are about 30 new data inserted to the Master every minute. The replication between them seems work well, but I find that Slave has more data than Master within some time period.
I am sure the data before the replication is the same on the Master and slave.
I am also sure that these external data in Slave must be from the Master, and they are not some random data, they are reasonable like other data. So I do not know how this data can be in the Slave, but not in the Master. Could someone tell me?
Maybe, I assume the potential reason is: some data do not insert to the Master successfully, but relevant logs have been written successfully into binary logs. Therefore, slave has more data, because the replication is based on these binary logs. Is it possible?
I have one Master and one Slave, tables are MyISAM in them. there are about 30 new data inserted to the Master every minute. The replication between them seems work well, but I find that Slave has more data than Master within some time period.
I am sure the data before the replication is the same on the Master and slave.
I am also sure that these external data in Slave must be from the Master, and they are not some random data, they are reasonable like other data. So I do not know how this data can be in the Slave, but not in the Master. Could someone tell me?
Maybe, I assume the potential reason is: some data do not insert to the Master successfully, but relevant logs have been written successfully into binary logs. Therefore, slave has more data, because the replication is based on these binary logs. Is it possible?
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Slave has more data than Master? | 1067 | Yang Jie | 02/21/2012 06:43AM |
| Re: Slave has more data than Master? | 518 | Irfan Ali | 02/22/2012 02:49AM |
| Re: Slave has more data than Master? | 536 | Yang Jie | 02/22/2012 10:23PM |
| Re: Slave has more data than Master? | 630 | Irfan Ali | 02/23/2012 06:01AM |
| Re: Slave has more data than Master? | 458 | Yang Jie | 02/24/2012 04:27AM |
| Re: Slave has more data than Master? | 478 | Rick James | 02/24/2012 07:26AM |
| Re: Slave has more data than Master? | 430 | Yang Jie | 03/05/2012 04:38AM |
| Re: Slave has more data than Master? | 350 | Yang Jie | 03/22/2012 05:26AM |
| Re: Slave has more data than Master? | 342 | Rick James | 03/23/2012 08:03PM |
| Re: Slave has more data than Master? | 470 | Yang Jie | 03/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.
© 2013, Oracle Corporation and/or its affiliates