Linux: MMwiki

mkdir /apps/work/service/mm-wiki/{mysql/data,wiki-data}

cd  /apps/work/service/mm-wiki/mysql/data

# mysql配置文件
cat << EOF > my.cnf
#For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
basedir=/var/lib/mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/tmp/mysql.sock
user=mysql
tmpdir=/tmp
max_connections=200
character-set-server=utf8
#sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=100
character-set-server=utf8
lower_case_table_names=1
skip-name-resolve
max_connections=3000
## 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8mb4
## 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
#lower_case_table_name=1
max_allowed_packet=1024M
max_length_for_sort_data=838860
group_concat_max_len=1844674407370954752
query_cache_type=1
loose_max_statement_time=3000000
table_open_cache=4096
max_connect_errors=100000
sort_buffer_size=3M
join_buffer_size=3M
log_bin_trust_function_creators=1
#开启慢日志
log_output=file
slow_query_log=on
slow_query_log_file = /var/lib/mysql/mysql-slow.log
log_queries_not_using_indexes=on
long_query_time = 1
sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/lib/mysql/error.log
pid-file=/var/lib/mysql/mysql.pid
[mysqldump]
user=root
password=123
EOF

cd  /apps/work/service/mm-wiki

cat << EOF > docker-compose.yaml 
version: "3.9"
services:
  mm-wiki:
    image: 217heidai/mm-wiki:0.2.1
    container_name: mm-wiki
    hostname: mm-wiki
    volumes:
      - ./wiki-data:/data # mm-wiki data
    ports:
      - "8888:8080"
    deploy:
      mode: replicated
      replicas: 2
      restart_policy:
        condition: on-failure
        delay: 5s
        max_attempts: 3
        window: 120s
      resources:
        limits:
          cpus: '0.8'
          memory: 500M
        reservations:
          cpus: '0.8'
          memory: 500M
    networks:
      mm-wiki:
        aliases:
          - mm-wiki
    depends_on:
      - db
  db:
    image: mysql:5.7
    container_name: mysql
    hostname: mysql
    volumes:
      - ./mysql/data:/var/lib/mysql
      - ./mysql/my.cnf:/etc/my.cnf
    environment:
      - MYSQL_ROOT_PASSWORD=123
      - TZ=Asia/Shanghai
    deploy:
      restart_policy:
        condition: on-failure
        delay: 5s
        max_attempts: 3
        window: 120s
      resources:
        limits:
          cpus: '0.8'
          memory: 500M
        reservations:
          cpus: '0.8'
          memory: 500M
    networks:
      mm-wiki:
        aliases:
          - db
networks:
  mm-wiki:
    name: mm-wiki
    driver: bridge
#ulimits:
#  nproc: 65535
#  nofile:
#    soft: 20000
#    hard: 40000
EOF

docker-compose up -d
docker-compose ps