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

# mysql8 docker 部署

https://abc.htmltoo.com/thread-46459.htm

docker run -d  -p  3306:3306   --privileged=true  --name mariadb --restart=always  -v /etc/localtime:/etc/localtime:ro  -v /data/site/docker/data/mysql:/var/lib/mysql -v  /data/site/docker/env/mysql/mysql57/my.cnf:/etc/mysql/my.cnf:ro  -e MYSQL_ROOT_PASSWORD='wdqdmm@r' -e MYSQL_ALLOW_EMPTY_PASSWORD='no' -v /data/file/logs/mysql57:/var/log/mysql  mysql:5.7

docker run -d  -p  3306:3306   --privileged=true  --name mariadb --restart=always  -v /etc/localtime:/etc/localtime:ro  -v /data/site/docker/data/mysql57:/var/lib/mysql -v  /data/site/docker/env/mysql/mysql57/my.cnf:/etc/mysql/my.cnf:ro  -e MYSQL_ROOT_PASSWORD=wdqdmm@r -e MYSQL_ALLOW_EMPTY_PASSWORD=no -v /data/file/logs/mysql57:/var/log/mysql  mysql:5.7  --max_allowed_packet=800M  --default-authentication-plugin=mysql_native_password

docker run -d  -p  3316:3306   --privileged=true  --name mysqltest --restart=always  -e MYSQL_ROOT_PASSWORD='wdqdmm@r' -e MYSQL_ALLOW_EMPTY_PASSWORD='no' -v /data/file/mysql:/var/lib/mysql  mysql:8 --max_allowed_packet='800M'  --bind-address='0.0.0.0'

docker exec -it mariadb  /bin/bash

cat  /data/site/docker/env/mysql/mysql57/my.cnf

[mysqld]
#skip-grant-tables
# 禁用DNS反响解析，就能大大加快MySQL连接的速度, 在MySQL的授权表中使用主机名了而只能用ip格式
#skip-name-resolve
symbolic-links=0
# 设置大小写不敏感
lower_case_table_names=1
skip-character-set-client-handshake
bind-address = 0.0.0.0
# 端口号
port=3306
# 数据目录
datadir=/var/lib/mysql
# 新模式或表时将使用的默认字符集
character-set-server = utf8mb4
collation_server = utf8mb4_general_ci
# 默认存储引擎
default_storage_engine = InnoDB
# 将 SQL 模式设置为严格
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#  最大连接数
#log_slave_updates
max_connections = 1024
max_connect_errors = 1000000
max_allowed_packet = 512M
interactive_timeout = 600
wait_timeout = 600
# 表缓存
table_open_cache=2000
# 表内存
tmp_table_size=16M
# 线程缓存
thread_cache_size=10
# 查询缓存
query_cache_type = ON
query_cache_size = 128M 

# 日志设置
server-id = 3306
#binlog_format = row
#设置过期时间为2天
#expire_logs_days =2
#log_bin = /var/log/mysql/binlog
log_error = /var/log/mysql/error.log
slow_query_log = ON
long_query_time = 10
log_timestamps = SYSTEM
slow_query_log_file = /var/log/mysql/slow.log
#general_log = ON
#general_log_file = /var/log/mysql/general.log

my.cnf

[mysqld]
skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/run/mysqld/mysqld.sock
!includedir /etc/mysql/conf.d/

# mysql-binlog清除

https://abc.htmltoo.com/thread-46460.htm

# greatsql 部署 - mysql

https://abc.htmltoo.com/thread-46270.htm