[ mysql开启binlog ]


my.cnf

[mysqld]
port=3306
server-id=1
log-bin=mysql-bin
binlog_format=row
binlog-do-db=shopping_mall_main

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

docker-compose.yml

version: '3'

services:
  db:
    image: mysql:latest
    restart: always
    environment:
      - MYSQL_DATABASE=shopping_mall_main
      - MYSQL_ROOT_PASSWORD=chenhaifeng
    ports:
      - "3306:3306"
    volumes:
      - ./datas/mysql/:/var/lib/mysql
      - ./conf/mysql/my.cnf:/etc/mysql/my.cnf
      - ./datas/mysql-files:/var/lib/mysql-files/
    depends_on:
      - redis
    container_name: db

  redis:
    restart: always
    image: redis:latest
    volumes:
      - ./datas/redis/:/data
    ports:
      - "6379:6379"
    container_name: redis