创建my.cnf
[mysqld]
##
server_id=1
##
binlog-ignore-db=mysql
##
log-bin=replicas-mysql-bin
##
binlog_cache_size=1M
##
binlog_format=mixed
##
expire_logs_days=7
# 设置 比较表名和数据库名时忽略大小写
lower_case_table_names=1
max_allowed_packet=125M
max_connections=200
max_connect_errors=10000
datadir =/var/lib/mysql
socket =/var/run/mysqld/mysqld.sock
#Encoding
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
[client]
# default-character-set = utf8
socket =/var/run/mysqld/mysqld.sock
创建docker-compose.yml
services:
mysql:
restart: always
image: biarms/mysql:5.7.30-linux-arm64v8
container_name: mysql
networks:
- db
ports:
- 3306:3306
environment:
- TZ=Asia/Shanghai
- MYSQL_ROOT_PASSWORD=123456
volumes:
- /data/mysql/conf/my.cnf:/etc/mysql/my.cnf
- /data/mysql/log:/var/log/mysql
- /data/mysql/data:/var/lib/mysql
command: [
'--explicit_defaults_for_timestamp=true',
'--character-set-server=utf8mb4',
'--collation-server=utf8mb4_general_ci',
'--max_connections=3000'
]
networks:
db:
external: true
启动
docker-compose up -d