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.)
Subject
Views
Written By
Posted
4110
March 17, 2010 02:30AM
1494
March 17, 2010 07:16AM
1483
March 17, 2010 07:47AM
1453
March 27, 2010 03:05AM
1314
March 27, 2010 10:10AM
Re: Need advice to Setup replication server (INNODB)
1783
March 18, 2010 09:19PM
1461
March 23, 2010 10:50AM
1447
March 23, 2010 11:05AM
1502
March 23, 2010 08:32PM
1436
March 27, 2010 02:51AM
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.