Docker build MySQL 8.0.21 with BinLog

Sep 6, 2020

1. 从docker hub 拉取mysql 8.0.21 

docker pull msyql:8.0.21 

也可以创建容器时候自动拉取

2. 创建config文件,用于配置mysql 

建议放到个人目录,很多guide都是放到/home/data下,实际上macOs等会出现权限问题 命令行执行: 

2.1 vi Users/wang/mysql8/config/my.cnf

2.2 把配置放入上文件并保存

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Custom config should go here
!includedir /etc/mysql/conf.d/

default_authentication_plugin= mysql_native_password

#bin log setting
log-bin = /var/lib/mysql/mysql-bin
binlog-format = ROW
server-id = 1

#client connect
bind-address = 0.0.0.0

3. 创建Mysql8容器 docker run 

-p 3307:3306 

-e MYSQL_ROOT_PASSWORD=root 

-v /Users/wang/mysql8/data:/var/lib/mysql:rw 

-v /Users/wang/mysql8/log:/var/log/mysql:rw 

-v /Users/wang/mysql8/config/my.cnf:/etc/mysql/my.cnf:rw

-v /etc/localtime:/etc/localtime:ro 

–name mysql8 

–restart=always 

-d mysql:8.0.21

如果/etc/localtime报错可以拿点，权限需要配置

4.启动容器并进入Mysql8查看binlog是否开启成功 

4.1 启动容器 docker start mysql8 

4.2 进入容器 docker exec -ti mysql8 bash 

4.3 登陆mysql mysql -u root -p 

4.4 查看binLog是否开启成功 show variables like ‘log_bin’

5. 网上有后期追加binlog的方式, 有一种通过容器内echo追加my.cnf里参数的方式貌似可行,大家可以自己尝试,成长在于折腾!