mariadb cluster主从

1、在主节点上/etc/my.cnf

service-id=1

在主库mysql授权backup用户的权限

grant replication slave on *.* to backup@'%' identified by 'password';

在终端导出全库 为保证数据库的偏移量一致性 加入--master-data=2

mysqldump -u root --master-data=2 --all-databases > /tmp/backup.sql

grep -i "change master to" /tmp/backup.sql 记录第一行的MASTER_LOG_FILE='mysql-bin.000006', MASTER_LOG_POS=59583;给从库上使用

或者在主库上执行 show master status\G 也可以查看

systemctl restart mariadb

2、在从节点上/etc/my.cnf

service-id=2

然后保存文件进入从库mysql执行

CHANGE MASTER TO

MASTER_HOST='192.168.1.2',

MASTER_USER='backup',

MASTER_PASSWORD='password',

MASTER_LOG_FILE='mysql-bin.000006',

MASTER_LOG_POS=59583;

start slave;启动从库

show slave status\G 查看状态 IO和SQL都为yes就ok了

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

show variables like 'server_id';

set global server_id=2

show global variables like '%max_connect_errors%';

 set global max_connect_errors=4000; 默认是100