两台主机,分别设置好yum源,关闭防火墙,selinux,配置好hosts,IP地址
我自己的地址是:
mariadb主:192.168.100.10/24
mariadb从:192.168.100.20/24
Mariadb 主
yum install –y mariadb mariadb-server galera Mariadb-Galera-server
vim /etc/my.cnf.d/server.cnf
[mysqld]
log_bin = mysql-bin
binlog_ignore_db = mysql
server_id = 10
systemctl restart mariadb
systemctl enable mariadb
mysql_sec………
mysql –uroot –p000000
grant replication on *.* to mysql2@’192.168.100.%’ identified by ‘000000’;
grant all privileges on *.* to mysql2@’%’ identified by ‘000000’;
grant all privileges on *.* to mysql2@’localhost’ identified by ‘000000’;
mariadb 从
yum install –y mariadb mariadb-server galera Mariadb-Galera-server
vim /etc/my.cnf.d/server.cnf
[mysqld]
log_bin = mysql-bin
binlog_ignore_db = mysql
server_id = 10
systemctl restart mariadb
systemctl enable mariadb
mysql_sec………
mysql –uroot –p000000
change master to master_host=’192.168.100.10’,master_user=’mysql2’,master_password=’000000’,master _port=3306,master_log_file='master-bin.0.000001',master_log_pos=245;
start slave;
show slave status\G
操作失误时会导致如下报错:
表数据已存在
解决方法删除库重新同步
日志异常:
重新导入日志文件change master to master_log_file='mariadb-bin.000001',master_log_pos=245;
账号故障:
排查账号详细故障并解决(密码错误、权限错误、用户名错误等)
详细故障可查询报错编号perror
补充:
mariadb主主的在此基础上只需要优化即可,两边同时创建一个用户,并赋权
然后分别再用change master to建立两端连接,就可以配置好主主了
这些集群的验证方法网上都有,我就懒得去复制粘贴了,希望能对大家有所帮助