//mysqldump --master-data建立主从服务
1、先dump一个库(主)
./mysqldump -uroot -p********* --opt --default-character-set=utf8 --extended-insert=true --single-transaction -R --flush-logs --master-data=1 --all-databases > 3.1bk.sql
2、查看dump出来的文件,file和position的值和上面是相同的
grep -i "change master to" 3.1bk.sql
3、编辑slave端的配置文件
[mysqld]
port = 3306
socket = /mydata/data/mysql.sock
skip-locking
key_buffer = 64M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
server-id = 3
master-host=10.200.3.1
master-port=3306
master-user=repl
master-password=*********
master-connect-retry=60
//change master to master_host='10.200.3.1',master_user='repl',master_password='*********';
4、重启slave端mysql
service mysqld restart
5、此时netstat -an|grep 3306 看到slave master的连接已经建立,现在不需要他们之间连接,登录slave端,执行:
netstat -an|grep 3306
slave stop;
6、导入master导出的文件
>source /root/3.1bk.sql;
7、开启slave端同步
start slave;
show slave status\G;