MariaDB主主同步，也就是两个MariaDB之间互为主从，每个MariaDB均为主、从双角色。
网站建设哪家好，找成都创新互联！专注于网页设计、网站建设、微信开发、小程序开发、集团企业网站建设等服务项目。为回馈新老客户创新互联还提供了五指山免费建站欢迎大家使用！
1. MariaDB01配置
vi /etc/my.cnf.d/server.cnf
[MySQLd]
server-id = 1
log-bin = master-log
relay-log = slave-log
auto_increment_offset = 1
auto_increment_increment = 2
2. MariaDB02配置
vi /etc/my.cnf.d/server.cnf
[mysqld]
server-id = 2
log-bin = master-log
relay-log = slave-log
auto_increment_offset = 2
auto_increment_increment = 2
3. 重启MariaDB服务
root用户： sudo -u mysql service mysql restart
mysql用户：service mysql restart
4. MariaDB01主，MariaDB02从配置
MariaDB01执行：
CREATE USER 'repl'@'192.168.10.%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.10.%';
show master status;
MariaDB02执行：
CHANGE MASTER TO MASTER_HOST='192.168.10.178', MASTER_USER='repl', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-log.000002', MASTER_LOG_POS=329;
start slave;
show slave status\G
5. MariaDB02主，MariaDB01从配置
MariaDB02执行：
CREATE USER 'repl'@'192.168.10.%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.10.%';
show master status;
MariaDB01执行：
CHANGE MASTER TO MASTER_HOST='192.168.10.179', MASTER_USER='repl', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-log.000002', MASTER_LOG_POS=329;
start slave;
show slave status\G
至此，主主同步复制配置完成。
