MariaDB主主同步,也就是两个MariaDB之间互为主从,每个MariaDB均为主、从双角色。1. MariaDB01配置vi /etc/my.cnf.d/server.cnf[Mysqld]serve
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
至此,主主同步复制配置完成。
--结束END--
本文标题: MariaDB 10.3 主主同步复制
本文链接: https://www.lsjlt.com/news/44334.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
2024-04-30
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0