docker-compose 创建MySQL5.7和8.0

一颗大大大萝卜呗

已于 2023-12-19 14:00:57 修改

阅读量1.2k

点赞数

分类专栏： Docker 文章标签： docker mysql 数据库

于 2020-01-08 16:54:35 首次发布

本文链接：https://blog.csdn.net/qq_41967899/article/details/103894424

版权

Docker 专栏收录该内容

35 篇文章 1 订阅

订阅专栏

5.7.*版本

version: '3.1'
services:
  db:
    restart: always
    image: mysql:5.7.22
    container_name: mysql_5.7
    ports:
      - 3306:3306
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: 123456
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M
      --sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
    volumes:
      - ./data:/var/lib/mysql

8.0.*版本

version: '3'
services:
  mysql8.0:
    image: mysql8.0
    restart: always
    container_name: mysql8.0
    privileged: true # 解决可能出现创建文件的权限问题
    ports:
      - 3307:3306
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: 123456
    volumes:
      - ./data:/var/lib/mysql
      - ./conf:/etc/mysql
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1

注意修改隔离级别(重启也不会失效)
/etc/mysql/conf.d/docker.cnf

[mysqld]
skip-host-cache
skip-name-resolve
transaction_isolation=read-committed ## 重点是添加这句。不然是REPEATABLE-READ可重复读的隔离级别。

临时需改

select @@global.transaction_isolation,@@transaction_isolation;
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
select @@global.transaction_isolation,@@transaction_isolation;