mysql master slave deployment

#开启binlog
log_bin=/data/binlog/mysql-bin

#主库进行备份
innobackupex --defaults-file=/etc/my.cnf --socket=/data/binlog/mysql.sock --stream=tar /backup/xtrabackup/ 2>/backup/bak_log/$log | gzip 1>/backup/xtrabackup/xtrabackup.tar.gz

#从库停服务清理数据目录
service mysqld stop
rm -rf /data/*
mkdir -p /data/{binlog,log,mysqldata,relay_log}

#还原文件
tar -xvf xtrabackup.tar -C /data/mysqldata/
touch /data/log/mysqld.err
chown -R mysql:mysql /data
innobackupex --defaults-file=/etc/my.cnf --use-memory=800M --apply-log /data/mysqldata

#重启跳过执行事务
service mysqld start

gtid=`awk '{print $3}' /data/mysqldata/xtrabackup_binlog_info`

echo $gtid

mysql <reset master;
set global gtid_purged="$gtid";
show master status;

change master to master_host='192.168.136.123', master_user='replica_user',master_password='Pas5w@rd',master_auto_position=1;
start slave;
show slave status \G;

set global super_read_only=on;
eof