Re: Process to reload master database of master/slave pair - 04-02-2012 , 05:44 PM
red_valsen <red_valsen (AT) yahoo (DOT) com> wrote:
mysqldump creates a (rather big) bunch of DDL and DML SQL statements.
Loading a dump means executing those statements. Replication will
handle this just like any other SQL workload that modifies data.
The question is rather if this makes sense. Normally you're better
off to disable binlogging while loading the dump, because this will
speed up this operation on the master (and thus reduce the downtime).
Of course you will then also have to load the same dump into the
slave(s) and resume replication with the binlog started after
initializing the master.