NNIPMS

Appearance

MariaDB 12 数据库配置 ​

版本信息 ​

  • 镜像: mariadb:12-alpine
  • 驱动: mysql（与 MySQL 完全兼容）
  • 默认端口: 3306

环境变量配置（推荐） ​

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

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

完整服务（内置 MariaDB） ​

创建 docker-compose.yml：

yaml
name: nnipms-mariadb

services:
  db:
    image: mariadb:12-alpine
    container_name: nnipms-mariadb
    restart: unless-stopped
    environment:
      MARIADB_ROOT_PASSWORD: ${MARIADB_ROOT_PASSWORD:-root123}
      MARIADB_DATABASE: ${MARIADB_DATABASE:-nnipms_db}
      MARIADB_USER: ${MARIADB_USER:-nnipms_user}
      MARIADB_PASSWORD: ${MARIADB_PASSWORD:-Hf#XE6h2f*#HrU}
    command:
      - --character-set-server=utf8mb4
      - --collation-server=utf8mb4_unicode_ci
      - --max_connections=200
    ports:
      - "${MARIADB_PORT:-3306}:3306"
    volumes:
      - ./data/mariadb:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mariadb-admin", "ping", "-h", "localhost", "-u", "root", "-p${MARIADB_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: ${MARIADB_USER:-nnipms_user}
      DB_PASSWORD: ${MARIADB_PASSWORD:-Hf#XE6h2f*#HrU}
      DB_NAME: ${MARIADB_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
MARIADB_PORT=3306
MARIADB_USER=nnipms_user
MARIADB_PASSWORD=Hf#XE6h2f*#HrU
MARIADB_DATABASE=nnipms_db
MARIADB_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（MariaDB 使用 MySQL 驱动）：

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

外部 MariaDB ​

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

创建 config/mysql.external.toml：

toml
[database]
driver = "mysql"
host = "你的MariaDB主机地址"
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-mariadb-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 的兼容性 ​

MariaDB 12 完全兼容 MySQL 协议和 SQL 语法，NNIPMS 中使用 driver = "mysql" 即可连接。现有 MySQL 的备份文件可直接恢复到 MariaDB。

首次安装 ​

MariaDB 首次启动时自动创建用户和数据库，也可手动操作：

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-mariadb mariadb-dump -u nnipms_user -p nnipms_db > backup_$(date +%Y%m%d).sql

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

Copyright © 2026 NNIPMS Team