mysql 两台主主复制配置

时间:2023-03-10 03:22:29
mysql 两台主主复制配置

A.服务器

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port= server-id=
#master-host=10.1.50.41
#master-user=root
#master-password=abc@
#master-port=
#master-connect-retry=
replicate-do-db=test
log-bin=log-slave-updates
binlog-ignore-db=mysql
slave-skip-errors=all
auto_increment_offset =
auto_increment_increment =

B.服务器

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=
server-id=
#master-host=10.1.50.40
#master-user=root
#master-password=abc@
#master-port=
#master-connect-retry=
replicate-do-db=Test
log-bin=log-slave-updates
binlog-ignore-db=mysql
slave-skip-errors=all
auto_increment_offset =
auto_increment_increment =

这是2台服务器配置,一个是1,3,5,7增加 一个是2,4,6,8增加