## **在线增加从服务器：** 1. 从库导出主库数据 ``` mysqldump -h192.168.230.101 -uroot -p123456 --defaultcharacter-set=utf8 --databases test --single-transaction -- master-data=2 > test.sql ``` 2. 从库导入数据 ``` mysql -uroot -p123456 --default-character-set=utf8 < test.sq ``` 3. change master to 连接 ``` change master to master_host='192.168.230.101',master_port=3306,maste r_user='repl',master_password='123456',master_log_file= 'mysql-bin.000003',master_log_pos=1142; ``` 4. 开启 slave