grant replication slave on *.* to 'repl'@'%' identified by 'repl4slave';
备份:
mysqldump(数据量不大)
mysqldump --master-data=2 --single-transaction -A > node1_3306_20160120.sql
innobackupex
mysqldump --master-data=2 --single-transaction -A > ddd.sql
(2)192.168.0.101
mysql < ddd.sql
change master to
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=791;
change master to master_host='192.168.0.100',master_port=3306,master_user='repl',master_password='repl4slave',master_auto_position=1;
change master to master_host='192.168.0.100',master_user='repl',master_password='repl4slave',master_log_file='mysql-bin.000003',master_log_pos=791;