使用docker-compose搭建达梦数据库主备集群

目录

1. Docker集群的搭建

2. 检查主备数据库

3. 主备集群的JDBC连接设置

---

1. Docker集群的搭建

达梦的镜像文件都是tar文件，通过docker load命令导入：

docker load -i dm8_20240422_x86_rh6_64_rq_ent_8.1.3.140.tar

成功导入后，可看到镜像的仓库名和标签：

docker images

REPOSITORY   TAG                                 IMAGE ID       CREATED       SIZE
dm8          dm8_20240422_rev222308_x86_rh6_64   c6c32f5a271c   6 weeks ago   1.25GB

选择一个目录创建我们的docker-compose.yml文件：

networks:
  dmnet:
    driver: bridge
    ipam:
      config:
        - subnet: 172.20.0.0/24
services:
  dm_monitor:
    container_name: dm_monitor
    image: dm8:dm8_20240422_rev222308_x86_rh6_64
    networks:
      dmnet:
        ipv4_address: 172.20.0.2
    restart: always
    volumes:
      - ./data/monitor:/opt/dmdbms/data
    environment:
      - MODE=docker_dmwatcher
      - PAGE_SIZE=16
      - CASE_SENSITIVE=1
      - UNICODE_FLAG=1
      - LENGTH_IN_CHAR=1
      - SYSDBA_PWD=SYSDBA001
      - DMWATCHER_ROLE=monitor
      - CLUSTER_IPS="172.20.0.2,172.20.0.3,172.20.0.4"
      - LD_LIBRARY_PATH=/opt/dmdbms/bin
  dm_primary:
    container_name: dm_primary
    image: dm8:dm8_20240422_rev222308_x86_rh6_64
    networks:
      dmnet:
        ipv4_address: 172.20.0.3
    ports:
      - '30136:5236'
    restart: always
    volumes:
      - ./data/primary:/opt/dmdbms/data
    environment:
      - MODE=docker_dmwatcher
      - PAGE_SIZE=16
      - CASE_SENSITIVE=1
      - UNICODE_FLAG=1
      - LENGTH_IN_CHAR=1
      - SYSDBA_PWD=SYSDBA001
      - DMWATCHER_ROLE=primary
      - DW_NO=1
      - CLUSTER_IPS="172.20.0.2,172.20.0.3,1