快速搭建开发环境-mysql服务器

使用docker-compose启动一个服务, 对外暴露默认端口

默认数据初始化:
将*.sql文件存放到 .storage/initial/ 容器第一次启动(即mysql data目录无内容)时会使用sql文件自动初始化数据库.

注意:
* 需要添加 create database if not exist database_name;
* 需要添加 use database_name;

TARGET=/opt/infra/dev/mysql
mkdir -p ${TARGET}
cd ${TARGET}
tee ./docker-compose.yml <<- 'EOF'
version: "3.7"
networks:
  infra_dev_network:
    driver: bridge
services:
  infra_dev_mysql:
    ports:
      - 3306:3306
    image: "mysql:5.7"
    container_name: "infra_dev_mysql"
    restart: "unless-stopped"
    networks:
      - "infra_dev_network"
    volumes:
      - "./.storage/data/mysql/data:/var/lib/mysql"
      - "./.storage/initial:/docker-entrypoint-initdb.d"
    command: "--innodb_file_per_table --lower_case_table_names=1 --skip-ssl --character_set_server=utf8mb4\
      \ --collation_server=utf8mb4_general_ci --max_allowed_packet=256M --max_connections=500  --log-bin=/var/lib/mysql/mysql-bin --server-id=417"
    environment:
      - "MYSQL_ROOT_PASSWORD=root"