创建文件夹并进入/data/docker/,创建docker-compose-mysql.yml,并复制配置内容
执行:docker-compose -f /data/docker/docker-compose-mysql.yml up -d
version: '3.8'networks:base:services:## 简单部署mysql:container_name: mysqlhostname: mysqlimage: mysql:8.0.28restart: alwaysenvironment:MYSQL_ROOT_PASSWORD: 123456TZ: Asia/Shanghaiports:- "3306:3306"security_opt:- seccomp:unconfinedvolumes:- ./mysql/conf:/etc/mysql/conf- ./mysql/log:/var/log/mysql- ./mysql/data:/var/lib/mysqlcommand:--default-authentication-plugin=mysql_native_password--character-set-server=utf8mb4--collation-server=utf8mb4_general_ci--explicit_defaults_for_timestamp=true--log-bin=mysql.bin--binlog-format=ROW--max_connections=10000--lower_case_table_names=1--server_id=11 # 须修改,每个节点不可重复## 具体调优配置需genuine实际情况进行调优# --sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION# --back_log=500# --max_allowed_packet=16M# --bulk_insert_buffer_size=1G# --innodb_buffer_pool_size=12G# --innodb_log_file_size=4G# --innodb_log_buffer_size=16M# --innodb_buffer_pool_instances=2# --innodb_flush_log_at_trx_commit=0# --innodb_thread_concurrency=16# --innodb_write_io_threads=16# --innodb_buffer_pool_instances=1# --innodb_flush_method=O_DIRECT# --innodb_io_capacity=2000# --innodb_io_capacity_max=6000# --query_cache_size=64M# --query_cache_type=1# --join_buffer_size=16M# --read_buffer_size=1M# --max_heap_table_size=64Mnetworks:- base
