mysql创建从库（未验证）

1.mysql添加从库
node1 主库
node2 新服务器

2.node1已经配置免密码SSH登陆到node2
在node2上执行
ssh-keygen -t rsa
在node1上新建
authorized_keys
将node2中的id_rsa.pub中的内容，添加到node1的authorized_keys

3.两台机器上都安装percona-xtrabackup
sudo yum install https://www.percona.com/downloads/percona-release/redhat/latest/percona-release-0.1-4.noarch.rpm
yum list | grep percona-xtrabackup
yum install percona-xtrabackup-24

4.两台机器上安装lz4
yum install lz4 -y

5.在node2上创建/tmp/mysql
6.执行同步
innobackupex --user=root --password=root --parallel=4 --socket=/var/lib/mysql/mysql.sock --no-timestamp
–stream=xbstream . | lz4 -B4 | ssh node2 “cat - | lz4 -d -B7 | xbstream -x -C /tmp/mysql”

7.innobackupex --apply-log /tmp/mysql/# 导入数据后，还要执行下整理操作
8.innobackupex --copy-back /tmp/mysql/ # 将整理好的数据库文件导入到原先的mysql datadir里
9.chown mysql.mysql /data/mysql/ -R
确保serverid不相同
/etc/init.d/mysql start 这样一台mysql就启动好了

10.cat /data/backup/full/xtrabackup_binlog_info
　　mysql-bin.0000022 1231231

–登录到slave库执行下列语句开启同步
[slave]
change master to
master_host=‘xxxx’,
master_user=‘repl’,
master_password=‘repl’,
master_port=3306,
master_log_file=‘mysql-bin.0000022’,
master_log_pos=1231231;
start slave;
show slave status\G;