创建文件夹并进入/data/docker/,创建docker-compose-mysql.yml,并复制配置内容
    执行:docker-compose -f /data/docker/docker-compose-mysql.yml up -d

    1. version: '3.8'
    2. networks:
    3. base:
    4. services:
    5. ## 简单部署
    6. mysql:
    7. container_name: mysql
    8. hostname: mysql
    9. image: mysql:8.0.28
    10. restart: always
    11. environment:
    12. MYSQL_ROOT_PASSWORD: 123456
    13. TZ: Asia/Shanghai
    14. ports:
    15. - "3306:3306"
    16. security_opt:
    17. - seccomp:unconfined
    18. volumes:
    19. - ./mysql/conf:/etc/mysql/conf
    20. - ./mysql/log:/var/log/mysql
    21. - ./mysql/data:/var/lib/mysql
    22. command:
    23. --default-authentication-plugin=mysql_native_password
    24. --character-set-server=utf8mb4
    25. --collation-server=utf8mb4_general_ci
    26. --explicit_defaults_for_timestamp=true
    27. --log-bin=mysql.bin
    28. --binlog-format=ROW
    29. --max_connections=10000
    30. --lower_case_table_names=1
    31. --server_id=11 # 须修改,每个节点不可重复
    32. ## 具体调优配置需genuine实际情况进行调优
    33. # --sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    34. # --back_log=500
    35. # --max_allowed_packet=16M
    36. # --bulk_insert_buffer_size=1G
    37. # --innodb_buffer_pool_size=12G
    38. # --innodb_log_file_size=4G
    39. # --innodb_log_buffer_size=16M
    40. # --innodb_buffer_pool_instances=2
    41. # --innodb_flush_log_at_trx_commit=0
    42. # --innodb_thread_concurrency=16
    43. # --innodb_write_io_threads=16
    44. # --innodb_buffer_pool_instances=1
    45. # --innodb_flush_method=O_DIRECT
    46. # --innodb_io_capacity=2000
    47. # --innodb_io_capacity_max=6000
    48. # --query_cache_size=64M
    49. # --query_cache_type=1
    50. # --join_buffer_size=16M
    51. # --read_buffer_size=1M
    52. # --max_heap_table_size=64M
    53. networks:
    54. - base