http://database.51cto.com/art/200510/8434.htm
http://imysql.cn/node/56
http://yemaosheng.com/?p=86
setup
要求mysql的版本比较接近
master my.cnf
[mysqld]
log-bin
server-id=1
master
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass';
restart mysql;
FLUSH TABLES WITH READ LOCK;
tar zcvf mysql-snapshot.tar.gz .
cp tar.gz to slave
tar zxvf tar.gz
show master status;
UNLOCK TABLES;
slave my.cnf
[mysqld]
server-id=slave_id
slave
CHANGE MASTER TO MASTER_HOST='master_host_name',MASTER_USER='replication_user_name',MASTER_PASSWORD='replication_password',MASTER_LOG_FILE='recorded_log_file_name',MASTER_LOG_POS=recorded_log_position;
start slave;
#1