mysql容器的主从复制_docker 容器模式下部署mysql 主从复制

1.计划用两台host来部署，分别部署一台 mysql,一主一从，2.配置好主从mysql配置文件，更改文件名即可[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysqld_safe]pid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.socknice = 0[mysqld]user = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplc-messages-dir = /usr/share/mysqlexplicit_defaults_for_timestamplog-bin = mysql-bin server-id = 1 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESsymbolic-links=0!includedir /etc/mysql/conf.d/!includedir /etc/mysql/mysql.conf.d/主与从server-id = 1 修改为server-id = 23.启动 mysql 容器，两个主机的容器都要启动，端口分别为3306,3307docker run -d -e MYSQL_ROOT_PASSWORD=123456 --name mysql-master -v /root/docker-mysql-data/mysql-master:/var/lib/mysql -v /root/docker-mysql-data/my-master.cnf:/etc/mysql/my.cnf -p 3306:3306 mysql:5.6测试：mysql -uroot -p123456 -h127.0.0.1登录本机的mysql容器内4.进入主mysql 容器创建一个用户，并授予权限，replication slave ,grant replication slave on *.* to ‘slave’@’%’ identified by ‘123456’; flush privileges;show master status;5. 从mysql容器配置change master to master_host=‘172.17.0.2‘,master_user=‘slave‘,master_password=‘slave‘,master_log_file=‘mysql-bin.000004‘,master_log_pos=1160,master_port=3306;mysql> start slave;mysql> show slave status \G；