NNIPMS

Appearance

MySQL 9 数据库配置 ​

版本信息 ​

  • 镜像: mysql:9.7.0
  • 驱动: mysql
  • 默认端口: 3306

环境变量配置（推荐） ​

从 v2.0 开始，后端支持通过环境变量配置数据库连接，无需 TOML 文件：

环境变量说明默认值
DB_DRIVER数据库驱动mysql
DB_HOST数据库主机—
DB_PORT数据库端口3306
DB_USER用户名—
DB_PASSWORD密码—
DB_NAME数据库名—

完整服务（内置 MySQL） ​

创建 docker-compose.yml：

yaml
name: nnipms-mysql

services:
  db:
    image: mysql:9.7.0
    container_name: nnipms-mysql
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-root123}
      MYSQL_DATABASE: ${MYSQL_DATABASE:-nnipms_db}
      MYSQL_USER: ${MYSQL_USER:-nnipms_user}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD:-Hf#XE6h2f*#HrU}
    command:
      - --character-set-server=utf8mb4
      - --collation-server=utf8mb4_unicode_ci
      - --max_connections=200
    ports:
      - "${MYSQL_PORT:-3306}:3306"
    volumes:
      - ./data/mysql:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-p${MYSQL_ROOT_PASSWORD:-root123}"]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s

  valkey:
    image: valkey/valkey:9-alpine
    container_name: nnipms-valkey
    restart: unless-stopped
    command:
      - valkey-server
      - --maxmemory ${VALKEY_MAX_MEMORY:-1024}mb
      - --maxmemory-policy ${VALKEY_MAX_MEMORY_POLICY:-allkeys-lru}
    ports:
      - "${VALKEY_PORT:-6379}:6379"
    volumes:
      - ./data/valkey:/data
    healthcheck:
      test: ["CMD", "valkey-cli", "ping"]
      interval: 10s
      timeout: 3s
      retries: 3

  backend:
    image: ccr.ccs.tencentyun.com/nnipms/backend:latest
    container_name: nnipms-backend
    restart: unless-stopped
    network_mode: host
    depends_on:
      db:
        condition: service_healthy
      valkey:
        condition: service_healthy
    environment:
      TZ: Asia/Shanghai
      CORS_ORIGINS: ${CORS_ORIGINS:-http://localhost:8848,http://127.0.0.1:8848}
      DB_DRIVER: ${DB_DRIVER:-mysql}
      DB_HOST: ${DB_HOST:-127.0.0.1}
      DB_PORT: "${DB_PORT:-3306}"
      DB_USER: ${MYSQL_USER:-nnipms_user}
      DB_PASSWORD: ${MYSQL_PASSWORD:-Hf#XE6h2f*#HrU}
      DB_NAME: ${MYSQL_DATABASE:-nnipms_db}
      DB_SSLMODE: ${DB_SSLMODE:-disable}
      VALKEY_ADDRESS: ${VALKEY_ADDRESS:-127.0.0.1}
      VALKEY_PORT: "${VALKEY_PORT:-6379}"
    volumes:
      - ./config:/app/config
      - ./log:/app/log
    command:
      - -c
      - config/mysql.toml
      - -p
      - "${BACKEND_PORT:-12339}"
      - -a
      - "${BACKEND_ADDR:-0.0.0.0}"

  frontend:
    image: ccr.ccs.tencentyun.com/nnipms/dashboard:latest
    container_name: nnipms-frontend
    restart: unless-stopped
    network_mode: host
    depends_on:
      backend:
        condition: service_started
    environment:
      BACKEND_URL: http://127.0.0.1:${BACKEND_PORT:-12339}

创建 .env：

bash
MYSQL_PORT=3306
MYSQL_USER=nnipms_user
MYSQL_PASSWORD=Hf#XE6h2f*#HrU
MYSQL_DATABASE=nnipms_db
MYSQL_ROOT_PASSWORD=root123
VALKEY_PORT=6379
VALKEY_MAX_MEMORY=1024
BACKEND_PORT=12339
BACKEND_ADDR=0.0.0.0
CORS_ORIGINS=http://localhost:8848,http://127.0.0.1:8848

创建 config/mysql.toml：

toml
[database]
driver = "mysql"
host = "127.0.0.1"
port = 3306
username = "nnipms_user"
password = "Hf#XE6h2f*#HrU"
database = "nnipms_db"

[mysql]
charset = "utf8mb4"
parse_time = true
loc = "Local"

启动：

bash
docker compose up -d

已知问题

MySQL 9.x 对 TEXT/BLOB 类型的索引键有前缀长度要求，部分表的 uniqueIndex 字段（如 project_name）可能在表初始化时报错 BLOB/TEXT column used in key specification without a key length。如遇此问题，建议换用 MariaDB 12（完全兼容 MySQL 协议，使用 driver = "mysql" 连接），详见 MariaDB 部署文档。

外部 MySQL ​

如果已有 MySQL 实例，只需启动 Valkey、后端和前端。

创建 config/mysql.external.toml：

toml
[database]
driver = "mysql"
host = "你的MySQL主机地址"
port = 3306
username = "nnipms_user"
password = "你的数据库密码"
database = "nnipms_db"

[mysql]
charset = "utf8mb4"
parse_time = true
loc = "Local"

创建 docker-compose.yml（仅 Valkey + Backend + Frontend）：

yaml
name: nnipms-mysql-external

services:
  valkey:
    image: valkey/valkey:9-alpine
    container_name: nnipms-valkey
    restart: unless-stopped
    ports:
      - "${VALKEY_PORT:-6379}:6379"
    healthcheck:
      test: ["CMD", "valkey-cli", "ping"]

  backend:
    image: ccr.ccs.tencentyun.com/nnipms/backend:latest
    container_name: nnipms-backend
    restart: unless-stopped
    network_mode: host
    depends_on:
      valkey:
        condition: service_healthy
    environment:
      CORS_ORIGINS: ${CORS_ORIGINS:-http://localhost:8848,http://127.0.0.1:8848}
      DB_DRIVER: ${DB_DRIVER:-mysql}
      DB_HOST: ${DB_HOST:-127.0.0.1}
      DB_PORT: ${DB_PORT:-3306}
      DB_USER: ${DB_USER:-nnipms_user}
      DB_PASSWORD: ${DB_PASSWORD:-Hf#XE6h2f*#HrU}
      DB_NAME: ${DB_NAME:-nnipms_db}
      DB_SSLMODE: ${DB_SSLMODE:-}
      VALKEY_ADDRESS: ${VALKEY_ADDRESS:-valkey}
      VALKEY_PORT: "${VALKEY_PORT:-6379}"
    volumes:
      - ./config:/app/config
    command:
      - -c
      - config/mysql.external.toml
      - -p
      - "${BACKEND_PORT:-12339}"
      - -a
      - "${BACKEND_ADDR:-0.0.0.0}"

  frontend:
    image: ccr.ccs.tencentyun.com/nnipms/dashboard:latest
    container_name: nnipms-frontend
    restart: unless-stopped
    network_mode: host
    depends_on:
      backend:
        condition: service_started
    environment:
      BACKEND_URL: http://127.0.0.1:${BACKEND_PORT:-12339}

启动：

bash
docker compose up -d

首次安装 ​

MySQL 首次启动时会自动创建用户和数据库，但需注意字符集：

sql
-- 如需手动创建数据库
CREATE DATABASE nnipms_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'nnipms_user'@'%' IDENTIFIED BY '你的密码';
GRANT ALL PRIVILEGES ON nnipms_db.* TO 'nnipms_user'@'%';
FLUSH PRIVILEGES;

备份与恢复 ​

bash
# 备份
docker exec -t nnipms-mysql mysqldump -u nnipms_user -p nnipms_db > backup_$(date +%Y%m%d).sql

# 恢复
cat backup.sql | docker exec -i nnipms-mysql mysql -u nnipms_user -p nnipms_db

Copyright © 2026 NNIPMS Team