MySQL Forums
Forum List  »  InnoDB

Re: Master-Slave with InnoDB
Posted by: Rick James
Date: July 20, 2011 09:51AM

100GB -- hours.

Yes, with the right parameters on mysqldump, there is no problem of a delay between finishing the dump and building the slave. The critical info is the position in the binlog which corresponds to the point-in-time when the mysqldump was taken. Replication will (eventually) catchup.

If there are dependencies between table, you really ought to dump all the tables, not just the one in question. The need for the binlog position (above) may also necessitate dumping everything (or stopping _all_ writes).

An alternative to hours of downtime is if you already have an LVM (Logical Volume) set up for taking a "snapshot" for backing up the entire filesystem. A snapshot of the filesystem -- taken when mysql is stopped! -- can be loaded on the slave. A small number of tweaks are needed (esp, server_id, CHANGE MASTER).

The discussion of ALTER TABLE could be adapted for copying the table:
http://forums.mysql.com/read.php?22,427374,427627#msg-427627



Edited 1 time(s). Last edit at 07/20/2011 09:52AM by Rick James.

Options: ReplyQuote


Subject
Views
Written By
Posted
2951
July 13, 2011 01:43AM
1017
July 14, 2011 10:00AM
1052
July 15, 2011 12:04AM
783
July 15, 2011 10:13AM
1311
July 18, 2011 01:04AM
854
July 18, 2011 08:59AM
1760
July 19, 2011 02:14AM
910
July 19, 2011 09:04PM
909
July 20, 2011 01:40AM
Re: Master-Slave with InnoDB
1137
July 20, 2011 09:51AM
827
July 25, 2011 06:36AM
1101
July 25, 2011 09:26AM
1010
July 28, 2011 06:32AM
1013
S D
August 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.