docker compose 部署mysql主从 原理图: 一、先部署两个mysql 可以跨机器 也可以同一台 准备两个mysql.yml文件和my.cnf配置文件 (yml文件我放一起 可以自行拆开部署) version:'3.1'services: mysql: image: mysql:8restart: always container_name: mysql environment
version:'3.8'# 指定 Docker Compose 文件的版本services:# 定义服务database:# 服务的名称image:mysql:latest# 使用最新的 MySQL 镜像environment:# 设置环境变量MYSQL_ROOT_PASSWORD:root_password# 设置 Root 用户的密码ports:# 映射端口-"3306:3306"# 将主机的 3306 端口映射到容器的 3306 端口volumes:# 持久...
networks:-mysql_default mysql-slaver: image: mysql:8.0.24restart: always container_name: mysql-slaver volumes:- /var/lib/mysql/xbd-slaver:/var/lib/mysql ports:- "3307:3306"environment: MYSQL_ROOT_PASSWORD:"root"privileged:true# change master to master_host='mysql-master', master_user='root...
dabf950015cd mysql "docker-entrypoint.s…" 5 minutes ago Up 5 minutes 33060/tcp, 0.0.0.0:3307->3306/tcp, :::3307->3306/tcp mysql-master 1. 2. 3. 4. 5. 2、进入/mydata/mysql-master/conf目录下新建my.cnf [root@localhost /]# mkdir /mydata/mysql-master/conf [root@localhost /]# ...
##编写docker-compose文件 version: '2' services: mysql: container_name: mysql network_mode: "host" environment: MYSQL_ROOT_PASSWORD: "123456" image: test/mysql:1.0 restart: unless-stopped volumes: - "/usr/test/mysql/data:/var/lib/mysql" - "/usr/test/mysql/conf:/etc/mysql/conf.d" ...
完整的docker-compose.yaml如下: services: mysql-master: image: "mysql-community-server:8.0.34" ports: - "13306:3306" container_name: mysql-master environment: MYSQL_ROOT_PASSWORD: admin123456 MYSQL_ROOT_HOST: '%' MYSQL_DATABASE: 'db_hr' MYSQL_ALLOW_EMPTY_PASSWORD: 'no' MASTER_SYNC_USER:...
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'demodb', 'USER': 'root', 'PASSWORD': '123456', 'HOST': 'db', } } 这里的NAME就是docker-compose.yml文件中的MYSQL_DATABASE,PASSWORD为docker-compose.yml文件中的MYSQL_ROOT_PASSWORD,HOST为docker-compose.yml文件...
创建docker-compose文件内容如下 # docker-compose.yml version: '3' services: mysql: restart: "no" image: mysql:5.7.16 container_name: mysql-master volumes: - ./datadir:/var/lib/mysql - ./conf/mysql:/etc/mysql environment: - "MYSQL_ROOT_PASSWORD=123456" - "TZ=Asia/Shanghai" ports: -...
docker-compose.yml version: '3' # 指定了 Docker Compose 文件的格式版本,版本3是常用版本之一services:mysql:image: mysql:8.0 # https://hub.docker.com/_/mysql/container_name: mysqlrestart: unless-stopped # 指定了容器的重启策略,除了手动停止容器,其他情况都自动重启容器environment:- TZ=Asia/Shanghai...
3、MySQL主、从服务器docker-compose-mysql.yml文件 复制 version:'3'services:mysql:environment:## root账号的密码 MYSQL_ROOT_PASSWORD:root密码 TZ:Asia/Shanghai## 新建mysql账号 MYSQL_USER:'mysql_user' MYSQL_PASSWORD:mysql_user密码 MYSQL_DATABASE:'mysql_db' ...