群晖docker安装mysql - 工作备忘录

• 新建一个配置文件
  我是放在/volume1/docker/mysql/config/microi_mysql.cnf

[mysqld]
# 基础配置
lower_case_table_names = 1
character_set_server=utf8mb4
collation_server=utf8mb4_unicode_ci

# 连接配置
max_connections = 500
thread_cache_size = 100
table_open_cache = 2000

# 内存配置（8G优化）
innodb_buffer_pool_size = 6G
innodb_log_buffer_size = 256M
key_buffer_size = 512M
query_cache_size = 512M
tmp_table_size = 512M
max_heap_table_size = 512M

# 缓冲配置
sort_buffer_size = 8M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
join_buffer_size = 8M
thread_stack = 512K
binlog_cache_size = 2M

• 打开Container Manager，新增项目，yml文件为

version: '3.8'
services:
  mysql5.7:
    image: registry.cn-hangzhou.aliyuncs.com/microios/mysql:5.7
    container_name: mysql5.7
    restart: always
    tty: true
    stdin_open: true
    ports:
      - "2506:3306"
    environment:
      - MYSQL_ROOT_PASSWORD=密码（据说不能带#）
      - MYSQL_TIME_ZONE=Asia/Shanghai
    volumes:
      - /volume1/docker/mysql/data:/var/lib/mysql
      - /volume1/docker/mysql/config/microi_mysql.cnf:/etc/mysql/conf.d/microi_mysql.cnf
    deploy:
      resources:
        limits:
          memory: 8G
    logging:
      options:
        max-size: 10m
        max-file: "10"

• 启动成功后，ssh进入群晖

# sudo -i
# docker exec -it mysql5.7 bash
# mysql -u root -p #奇怪的是我这里需要直接空密码Enter键进入
# USE mysql; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
# FLUSH PRIVILEGES;

• 之后就可以远程连接了