vi /data/mysql/port-3306/my.cnf
log-bin=mysql-bin
CREATE USER 'mysync'@'masterhostaddr' IDENTIFIED BY '123123'; GRANT REPLICATION SLAVE ON . TO 'mysync'@'masterhostaddr' IDENTIFIED BY '123123';
SHOW MASTER STATUS;
set global read_only=1; flush tables with read lock; show global variables like "%read_only%";
change master to master_host='masterhostaddr',master_port=3306,master_user='mysync',master_password='123123',master_log_file='mysql-bin.000016',master_log_pos=107; start slave; SHOW SLAVE STATUS;
备注:分号分隔的才是完整Sql语句,不要被换行迷惑。只有Slave_IO_Running、Slave_SQL_Runnining都为Yes才表示配置成功。