-
下载mysql镜像
-
创建master实例并启动
docker run \ -p 3307:3306 \ --name mysql-master \ -v /mydata/mysql/master/log:/var/log/mysql \ -v /mydata/mysql/master/data:/var/lib/mysql \ -v /mydata/mysql/master/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql:5.7
修改配置文件
vi /mydata/mysql/master/conf/my.conf
[client] # 客户端设置,即客户端默认的连接参数 default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] # 服务端基本设置 init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8mb4' character-set-server = utf8mb4 collation-server = utf8mb4_general_ci skip-character-set-client-handshake skip_name_resolve
添加master主从复制部分配置
server-id = 1 # Mysql服务的唯一编号 每个mysql服务Id需唯一 log-bin = mysql-bin # 开启mysql binlog功能 read-only=0 # 是否只读,1是0否 binlog_do_db=gulimall_ums # 哪一个数据库的增删改查需要记录改动日志 binlog_do_db=gulimall_pms binlog_do_db=gulimall_oms binlog_do_db=gulimall_sms binlog_do_db=gulimall_wms binlog_do_db=gulimall_admin #... replicate-ignore-db=mysql # 哪些表需要忽略,一般是mysql的配置相关表 replicate-ignore-db=sys replicate-ignore-db=information_schema replicate-ignore-db=performance_schema
-
创建slave实例并启动
docker run \ -p 3317:3306 \ --name mysql-slaver-01 \ -v /mydata/mysql/slaver/log:/var/log/mysql \ -v /mydata/mysql/slaver/data:/var/lib/mysql \ -v /mydata/mysql/slaver/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql:5.7
server-id = 2 # Mysql服务的唯一编号 每个mysql服务Id需唯一 log-bin = mysql-bin # 开启mysql binlog功能 read-only=1 # 是否只读,1是0否 binlog_do_db=gulimall_ums # 哪一个数据库的增删改查需要记录改动日志 binlog_do_db=gulimall_pms binlog_do_db=gulimall_oms binlog_do_db=gulimall_sms binlog_do_db=gulimall_wms binlog_do_db=gulimall_admin #... replicate-ignore-db=mysql # 哪些表需要忽略,一般是mysql的配置相关表 replicate-ignore-db=sys replicate-ignore-db=information_schema replicate-ignore-db=performance_schema
-
为master授权用户来同步他的数据
-
进入master容器
docker exec -it mysql-master /bin/bash
-
进入mysql内部
mysql -uroot -p
-
授权root用户可以远程访问(这一步与主从同步无关)
放开3307和3317端口GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; FLUSH PRIVILEGES;
-
-
mysql主从复制
最新推荐文章于 2024-08-23 17:37:15 发布