docker mysql开启binlog

docker-compose

version: "3.1"

services:
  db:
    image: mysql:5.7.34
    volumes:
      - ./data/db:/var/lib/mysql
      - ./data/logs:/var/log/mysql
      - ./my.cnf:/etc/mysql/my.cnf  
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: abc123456
      TZ: Asia/Shanghai
      #      MYSQL_DATABASE: wordpress
      #      MYSQL_USER: wordpress
    ports:
      - 3306:3306   

修改mysql文件

[mysqld]
local-infile=0
datadir=/var/lib/mysql
user=mysql
symbolic-links=0

max_connections = 2000

#enable binlog
server_id=2
log-bin=mysql-bin
binlog-format=ROW
expire_logs_days = 30

重启容器即可

docker-compose restart db