docker配置mysql主备(热备)
- Master my.cnf 配置文件:
在home下创建/home/mysql-master/my.cnf文件(可根据实际情况进行更改)
[mysqld]
server_id = 1
log-bin= mysql-bin
read-only=0
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
- Slave my.cnf 配置文件:
在home下创建/home/mysql-slave/my.cnf文件(可根据实际情况进行更改)
[mysqld]
server_id = 2
log-bin= mysql-bin
read-only=1
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
- 配置网卡
vi /etc/sysctl.conf
添加