Skip navigation links

MySQL Forums :: Replication :: Slave has more data than Master?


Advanced Search

Re: Slave has more data than Master?
Posted by: Yang Jie ()
Date: March 22, 2012 05:26AM

I still do not know the reason, but there is another clue which I want to share:

Because configuration "myisam-recover=backup" is set in my.cnf, the master database server will create ".bak" files when the server is crashed. When I look at the time when these files were created and timestamps when these data (lost in master but be in slave) came to the Master, they are the same. In other words, data missing in Master and Fatal 1236 in Slave happened at the same time.

So, could someone tell me how these happen and How can I prevent it?

Regards

Options: ReplyQuote


Subject Views Written By Posted
Slave has more data than Master? 1366 Yang Jie 02/21/2012 06:43AM
Re: Slave has more data than Master? 638 Irfan Ali 02/22/2012 02:49AM
Re: Slave has more data than Master? 656 Yang Jie 02/22/2012 10:23PM
Re: Slave has more data than Master? 740 Irfan Ali 02/23/2012 06:01AM
Re: Slave has more data than Master? 564 Yang Jie 02/24/2012 04:27AM
Re: Slave has more data than Master? 587 Rick James 02/24/2012 07:26AM
Re: Slave has more data than Master? 550 Yang Jie 03/05/2012 04:38AM
Re: Slave has more data than Master? 452 Yang Jie 03/22/2012 05:26AM
Re: Slave has more data than Master? 434 Rick James 03/23/2012 08:03PM
Re: Slave has more data than Master? 560 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.