环境
ubuntu 18.04
mysql 5.7
xtrabackup 2.4
主设置
vi /etc/mysql/mysql.conf.d/mysqld.cnf
server-id = 1
log-bin = /var/log/mysql/mysql-bin
sudo systemctl restart mysql
配置远程用户
CREATE USER 'repl'@'10.0.0.0' IDENTIFIED BY '密码';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'10.0.0.0';
FLUSH PRIVILEGES;
安装xtrabackup
备份
从恢复
查看位置
cat /data/backup/xtrabackup_binlog_info
Mysql 从配置
CHANGE MASTER TO
MASTER_HOST='master.mysql',
MASTER_USER='repl',
MASTER_PASSWORD='',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000031',
MASTER_LOG_POS=7823661;
--启动
START SLAVE;
主错误 Failed on my_net_write()
#主日志
2019