基于docker-compose的mysql部署

目录

├─conf
└─────my.cnf  //mysql配置文件
├─data //数据挂载目录
├─.env //环境变量
└─docker-compose.yml  //docker-compose配置

my.cnf

[mysqld]
user=mysql
default-storage-engine=INNODB
#character-set-server=utf8
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
default-time-zone='+8:00'
innodb_rollback_on_timeout='ON'
max_connections=500
innodb_lock_wait_timeout=500
[client]
#utf8mb4字符集可以存储emoji表情字符
#default-character-set=utf8
default-character-set=utf8mb4
[mysql]
#default-character-set=utf8
default-character-set=utf8mb4

.env

MYSQL_ROOT_PASSWORD=123456
MYSQL_ROOT_HOST=%
MYSQL_DATABASE=test

docker-compose.yml

version: '3'
services:
  mysql:
    restart: always
    # 镜像和版本
    image: mysql:5.7
    # 容器名称
    container_name: mysql
    volumes:
      # 挂载数据目录
      - ./data:/var/lib/mysql
      # 挂载配置文件目录
      - ./conf:/etc/mysql/conf.d
      # 数据库还原目录 可将需要还原的sql文件放在这里
      # - /docker/mysql/source:/docker-entrypoint-initdb.d
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_ROOT_HOST: ${MYSQL_ROOT_HOST}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      TZ: Asia/Shanghai
    ports:
      - 3306:3306
    networks:
      - itgr
networks:
  itgr:
    external: true

# docker network create itgr
# docker network ls

启动/停止运行

# 启动
$ docker-compose up -d
# 停止
$ docker-compose down