同一台机器用docker实现mysql的主从同步

1.创建映射的文件夹已经配置文件

/usr/mysql/mysql-master/my.cnf  (配置文件)
/usr/mysql/mysql-master/conf.d
/usr/mysql/mysql-master/data

 

/usr/mysql/mysql-slave/my.cnf  (配置文件)
/usr/mysql/mysql-slave/conf.d
/usr/mysql/mysql-slave/data

 

2.编写配置文件

2.1  编写/usr/mysql/mysql-master/my.cnf     

[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
pid-file		= /var/run/mysqld/mysqld.pid
socket			= /var/run/mysqld/mysqld.sock
datadir			= /var/lib/mysql
#log-error		= /var/log/mysql/error.log
#bind-address   = 127.0.0.1
expire_logs_days = 7
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=200
slow_query_log = ON
slow_query_log_file = /mnt/data/mysqlData/mysql/sql.log
long_query_time = 1
lower_case_table_names = 1
event_scheduler = ON
server-id = 3310
log-bin = mysql-bin
explicit_defaults_for_timestamp

[client]
default-character-set=utf8

2.2  编写/usr/mysql/mysql-slave/my.cnf

[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
pid-file		= /var/run/mysqld/mysqld.pid
socket			= /var/run/mysqld/mysqld.sock
datadir			= /var/lib/mysql
#log-error		= /va