使用 Windows powershell
cmd下使用会出现一系列问题
拉取镜像
docker pull mysql
创建容器
docker create --name mysqlsrv1 -v E:\docker\db\mysql\my1:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=你的密码 -p 3307:3306 mysql
启动容器
docker start mysqlsrv1
测试
docker ps
图片.png
docker exec -it mysqlsrv01
mysql -uroot -p
图片.png
tip：若提示 Error response from daemon: Drive has not been shared 请将设备磁盘设置为共享
图片.png
图片.png
tip：若此时使用 navicat 连接可能会出现
图片.png
alter user 'root'@'%' identified by '你的密码' password expire never;
alter user 'root'@'%' identified with mysql_native_password by '你的密码';
flush privileges;
alter user 'root'@'%' identified by '你的密码';
主从配置
# 高版本 当前版本：mysql Ver 14.14 Distrib 5.6.41, for Linux (x86_64) using EditLine wrapper
create user 'repldocker'@'192.168.0.%' identified by '密码';
GRANT REPLICATION SLAVE ON *.* TO 'repldocker'@'192.168.0.%';
GRANT REPLICATION SLAVE ON *.* TO 'repldocker'@'192.168.0.%'; IDENTIFIED BY '密码';
GRANT REPLICATION SLAVE ON *.* TO 'repldocker'@'192.168.0.%' IDENTIFIED BY '密码' with grant option;
修改主服务器配置
[mysqld]
log-bin=mysql-bin //[必须]启用二进制日志
server-id=140 //[必须]服务器唯一ID，默认是1，一般取IP最后一段
重启 service mysql restart
查看 binlog是否启用 show variables like '%log_bin%' ;
+---------------------------------+--------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------+
| log_bin | ON |
| log_bin_basename | /var/lib/mysql/mysql-bin |
| log_bin_index | /var/lib/mysql/mysql-bin.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| sql_log_bin | ON |
+---------------------------------+--------------------------------+
docker 安装 vim
-
apt update同步 /etc/apt/sources.list 和 /etc/apt/sources.list.d 中列出的源的索引 -
apt install vim安装 vim
尝试源码安装
ftp://ftp.vim.org/pub/vim/unix/
https://blog.csdn.net/gatieme/article/details/43883261
docker 下配置 mysql 从服务器 binlog
vim /etc/mysql/my.cnf
添加
log-bin=mysql-bin
server-id=3307
重启mysql容器
docker restart mysqlsrv1
简化版
docker exec mysqlsrv1 bash -c "echo 'log-bin=mysql-bin' >> /etc/mysql/my.cnf"
docker exec mysqlsrv1 bash -c "echo 'server-id=3307' >> /etc/mysql/my.cnf"
docker restart mysqlsrv1
change master to master_host='192.168.0.47', master_port=3306,master_user='repldocker',master_password='master中创建的用户密码',master_log_file='mysql-bin.000001',master_log_pos=120;
tip：配置中间用 , 尽量不用 空格
成功连接状态
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event 之前配置错误时一直显示： Connecting to master
Master_Host: 192.168.0.47
Master_User: repldocker
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 892
Relay_Log_File: fe1d594c7842-relay-bin.000002
Relay_Log_Pos: 318
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes 之前配置错误时一直显示： Connecting
Slave_SQL_Running: Yes
Master_Server_Id: 47
Master_UUID: 0684ced9-af5b-11e8-94fd-00163e0hhhhh 之前配置错误时此处为空；
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
