mysql配置文件
[client]
port = 3306
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
#GTID
server-id=1
#binlog
log_bin = master-bin
#log-slave-updates = 1
binlog_format = row
#sync-master-info = 1
#sync_binlog = 1
#relaylog
#skip_slave_start = 1
#跳过密码登陆
#skip-grant-tables
#auto-increment-increment=2
#auto-increment-offset=1
#binlog_format=mixed
max_allowed_packet=4000M
wait_timeout=1814400
interactive_timeout = 28800
character-set-client-handshake = FALSE
character-set-server = utf8mb4
init-connect = 'SET NAMES utf8mb4'
collation-server = utf8mb4_general_ci
#collation_connection = utf8mb4_general_ci
lower_case_table_names=1
default-time-zone = '+08:00'
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/lib/mysql/error.log
secure_file_priv=/var/lib/mysql
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
max_connections = 5000
#指定MySQL允许的最大连接进程数。如果在访问数据库时经常出现"Too Many Connections"的错误提 示，则需要增大该参数值。
#general_log = 1
#将所有到达MySQL Server的SQL语句记录下来,默认关闭
#rpl_semi_sync_master_enabled = 1
#plugin-load=rpl_semi_sync_master=semisync_master.so
#rpl_semi_sync_master_timeout = 1000
#general_log_file = /var/lib/mysql/mysql.log
#general_log路径
#不配置binlog_group_commit从库无法做到基于事物的并行复制。
#binlog_group_commit_sync_delay = 100
#binlog_group_commit_sync_no_delay_count = 10
#为了数据安全再配置
#sync_binlog=1
#innodb_flush_log_at_trx_commit=1
#sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
docker 命令
docker run \
-d \
-p 13306:3306 \
--restart always \
--privileged=true \
-v /home/work/mysql/conf/my.cnf:/etc/mysql/my.cnf \
-v /home/work/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-e TZ="Asia/Shanghai" \
--name mysql \
mysql:8.0.18
