Ubuntu 20.04 双机热备之 MySQL 8 主主复制

1、简介

MySQL 主主复制，即每台master既是master，又是另一台服务器的slave。这样，任何一方所做的变更，都会通过复制应用到另外一方的数据库中，两个都能读能写。

 2、配置

# Server1 MySQL 配置

[mysqld]
user = mysql
bind-address = 0.0.0.0
mysqlx-bind-address = 127.0.0.1
key_buffer_size = 16M
myisam-recover-options = BACKUP
log_error = /var/log/mysql/error.log
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
max_binlog_size = 100M
binlog_do_db = analyst
binlog_ignore_db = mysql
binlog_format = MIXED
log-slave-updates
auto-increment-offset = 1
auto-increment-increment = 2

# Server2 MySQL 配置

[mysqld]
user = mysql
bind-address = 0.0.0.0
mysqlx-bind-address = 127.0.0.1
key_buffer_size = 16M
myisam-recover-options = BACKUP
log_error = /var/log/mysql/error.log
server-id = 2
log_bin = /var/log/mysql/mysql-bin.log
max_binlog_size = 100M
binlog_do_db = analyst
b