Skip navigation links

MySQL Forums :: InnoDB :: Master-Slave with InnoDB


Advanced Search

Re: Master-Slave with InnoDB
Posted by: Aftab Khan ()
Date: July 28, 2011 06:32AM

I would say firstly try using mk-table-checksum to see the difference between master and slave databases if the differences are not high then try mk-table-sync utility

http://www.maatkit.org/doc/mk-table-checksum.html
http://www.maatkit.org/doc/mk-table-sync.html

If you find alot of discrepancy then take online backup (it won't block write/read operations) using mysqldump with following switches

mysqldump --single-transaction --master-data=2 -A > all_databases.sql

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_single-transaction

Since your database is quite large then the db restore would take significantly longer to complete in this case use MySQL Enteripse backup tool that is a very efficient

http://www.mysql.com/trials/



Edited 2 time(s). Last edit at 07/28/2011 10:00AM by Aftab Khan.

Options: ReplyQuote


Subject Views Written By Posted
Master-Slave with InnoDB 2139 emil öhgren 07/13/2011 01:43AM
Re: Master-Slave with InnoDB 709 Rick James 07/14/2011 10:00AM
Re: Master-Slave with InnoDB 730 emil öhgren 07/15/2011 12:04AM
Re: Master-Slave with InnoDB 592 Rick James 07/15/2011 10:13AM
Re: Master-Slave with InnoDB 1045 emil öhgren 07/18/2011 01:04AM
Re: Master-Slave with InnoDB 567 Rick James 07/18/2011 08:59AM
Re: Master-Slave with InnoDB 1315 emil öhgren 07/19/2011 02:14AM
Re: Master-Slave with InnoDB 641 Rick James 07/19/2011 09:04PM
Re: Master-Slave with InnoDB 643 emil öhgren 07/20/2011 01:40AM
Re: Master-Slave with InnoDB 788 Rick James 07/20/2011 09:51AM
Re: Master-Slave with InnoDB 568 emil öhgren 07/25/2011 06:36AM
Re: Master-Slave with InnoDB 776 Rick James 07/25/2011 09:26AM
Re: Master-Slave with InnoDB 648 Aftab Khan 07/28/2011 06:32AM
Re: Master-Slave with InnoDB 722 S D 08/09/2011 03:22PM


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.