1. 物理部署

1.1. 文档地址

MySQL5.7 的物理部署文档如下：

http://doc.bpmhome.cn/docs/ibps_v3_deploy/ibps_v3_deploy-1bkicht7l6o49

2. 容器部署

2.1. 前置工作

# 创建 数据目录
mkdir -p /opt/mysql57/data
# 创建 配置目录
mkdir -p /opt/mysql57/conf
# 创建 日志目录
mkdir -p /opt/mysql57/logs
# 创建 配置文件
touch /opt/mysql57/conf/mysql.cnf
# 创建 容器描述文件
touch /opt/mysql57/docker-compose.yml
# 授权 数据目录
chmod -R +x /opt/mysql57/data

2.2. 配置文件

[client]
default-character-set = utf8

[mysqld]
port = 3306
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci
max_connections = 1024 # 最大连接数量
max_allowed_packet = 64M
lower_case_table_names = 1 # 关闭大小写敏感
innodb_buffer_pool_size = 256M
join_buffer_size = 256M
read_rnd_buffer_size = 16M
sort_buffer_size = 16M
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
symbolic-links=0

2.3. 描述文件

docker-compose.yml 容器描述文件如下：

version: '3.3'
service:
  mysql:
    container_name: mysql57
    image: mysql:5.7
    restart: on-failure
    environment:
      MYSQL_ROOT_PASSWORD=123456
      TZ=Asia/Shanghai
    ports:
      - 3306:3306
    volumes:
      - /etc/localtime:/etc/localtime # 同步时区
      - ./conf:/etc/mysql/conf.d # 配置文件
      - ./data:/var/lib/mysql # 数据目录
      - ./logs:/var/log/mysql # 日志目录

2.4. 启动容器

docker-compose -f /opt/mysql57/docker-compose.yml -p mysql57 up -d