MySQL Forums
Forum List  »  Replication

Re: Need advice to Setup replication server (INNODB)
Posted by: Rick James
Date: March 18, 2010 09:19PM

LOAD DATA FROM MASTER is deprecated. Instead,...
1. stop the master
2. copy all the entire mysql directory tree to the slave(s)
3. if you copy my.cnf (my.ini), be sure to change the server_id -- they MUST be distinct
4. bin logging must be on in master's my.cnf
5. start the master
6. CHANGE MASTER on each slave to tell it how to find the master. Specify pos=0 of the one (or first) binlog on the master.

By copying all the files, InnoDB will be safely copied. This includes ibdata1 and any files (.frm, and maybe .ibd) in database directories. (The iblog files are optional -- simplest to copy them.)

Options: ReplyQuote




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.