https://hub.docker.com/_/mysql/

docker run -d  -p 3306:3306  --name  mariadb  --restart=always -v /data/site/docker/env/mysql/mysql8/my.cnf:/etc/mysql/my.cnf:ro  -v /etc/localtime:/etc/localtime -v /data/file:/data/file -v /data/site/docker/data/mysql8:/var/lib/mysql   -v /data/file/logs/mysql8:/var/log/mysql -e MYSQL_ROOT_PASSWORD='wdqdmm@r'  mysql:latest  --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  --default-authentication-plugin=mysql_native_password

docker run -d  -p 3316:3306  --name mysql8  --restart=always -v /data/docker/mysql8/my.cnf:/etc/mysql/my.cnf:ro  -v /etc/localtime:/etc/localtime -v /data/file:/data/file/ -v /data/docker/3316:/var/lib/mysql  -v /data/docker/3316-mysql-files:/var/lib/mysql-files  -v /data/logs:/var/log/mysql -e MYSQL_ROOT_PASSWORD=r  mysql:latest  --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  --default-authentication-plugin=mysql_native_password

touch /data/logs/error.log

touch /data/logs/query.log

touch /data/logs/slow.log

mkdir -p  /data/docker/mysql8/    /data/file    /data/docker/3316/data   /data/docker/3316/mysql-files

chmod -R 777  /data/logs/   /data/docker/

vim  /data/docker/mysql8/my.cnf

[mysqld]
#skip-log-bin
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
default_authentication_plugin=mysql_native_password
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#数据强一致性
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_slave_enabled=1
#rpl_semi_sync_master_timeout=6000
#主机id，不能重复
server-id=1                      
#启用gtid类型，否则就是普通的复制架构
#gtid_mode = on
#强制GTID的一致性
#enforce_gtid_consistency = true
#启用二进制日志, row复制模式,具有最高性能.
binlog_format=row
log_bin                = /var/log/mysql/mysql-bin
log_bin_index          = /var/log/mysql/mysql-bin.index
log-error = /var/log/mysql/error.log
binlog_expire_logs_seconds        = 7
max_binlog_size         = 200M
# slaves
#默认读写状态为0,只读状态为1, 请去掉注释.
#read_only=1           
#作为从服务器时的中继日志
relay_log              = /var/log/mysql/relay-bin 
#开启中继日志索引           
relay_log_index        = /var/log/mysql/relay-bin.index       
#中继日志信息记录库
#relay-log-info-repository=TABLE 
#事务特性,最好设为1
sync_binlog            = 1                                    
#slave 更新是否记录到日志
log_replica_updates  =  on
auto-increment-increment = 2
auto-increment-offset = 1          #  id，不能重复
# 不同步mysql, information_schema, performance_schema这几个库
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=sys
general_log = 0
general_log_file = /var/log/mysql/query.log
#开启慢查询日志
slow_query_log=1
##超出时间设定值的SQL即被记录到慢查询日志
long_query_time = 2
slow_query_log_file = /var/log/mysql/slow.log
bind-address = 0.0.0.0
default_storage_engine  = InnoDB
#实时写，实时刷
innodb_flush_log_at_trx_commit=1
#skip-grant-tables
max_connections = 10000
max_allowed_packet = 500M
wait_timeout= 600
interactive_timeout = 600
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
# Custom config should go here
!includedir /etc/mysql/conf.d/