# 1. 安装Docker和Docker Compose
– 安装Docker
$ sudo yum install -y docker
– 启动Docker服务
$ sudo systemctl start docker
– 设置Docker开机自启
$ sudo systemctl enable docker
– 安装Docker Compose
$ sudo curl -L “https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)” -o /usr/local/bin/docker-compose
– 给Docker Compose添加执行权限
$ sudo chmod +x /usr/local/bin/docker-compose
– 验证安装
$ docker-compose –version
# 2. 配置Docker
– 配置Docker镜像加速
$ sudo vi /etc/docker/daemon.json
{
“registry-mirrors”: [“https://registry.docker-cn.com”]
}
– 重启Docker服务
$ sudo systemctl restart docker
# 3. 准备项目目录
– 创建项目目录 更多学习教程公众号风哥教程itpux_com
$ mkdir -p dm-cluster
$ cd dm-cluster

# 1. 创建docker-compose.yml文件
$ vi docker-compose.yml
version: ‘3.8’
services:
dm-master:
image: dameng/dm8:latest
container_name: dm-master
ports:
– “5236:5236”
volumes:
– master-data:/dm/data
– master-log:/dm/log
environment:
– DM_PASSWORD=SYSDBA
– DM_SERVER_TYPE=MASTER
networks:
– dm-network
restart: always
dm-slave:
image: dameng/dm8:latest
container_name: dm-slave
ports:
– “5237:5236”
volumes:
– slave-data:/dm/data from DB视频:www.itpux.com
– slave-log:/dm/log
environment:
– DM_PASSWORD=SYSDBA
– DM_SERVER_TYPE=SLAVE
– DM_MASTER_HOST=dm-master
– DM_MASTER_PORT=5236
networks:
– dm-network
restart: always
depends_on:
– dm-master
volumes:
master-data:
master-log:
slave-data:
slave-log:
networks:
dm-network:
driver: bridge

# 1. 启动集群
$ docker-compose up -d
# 2. 查看集群状态
$ docker-compose ps
# 3. 查看容器日志
$ docker-compose logs -f
# 4. 验证主从同步
– 连接主库
$ docker exec -it dm-master disql SYSDBA/SYSDBA
SQL> create table fgedu_test (id int primary key, name varchar(50));
SQL> insert into fgedu_test values (1, ‘test’);
SQL> commit;
– 连接从库
$ docker exec -it dm-slave disql SYSDBA/SYSDBA
SQL> select * from fgedu_test;
# 5. 停止集群
$ docker-compose down

# docker-compose.yml
version: ‘3.8’
services:
dm-master:
image: dameng/dm8:latest
container_name: dm-master
ports:
– “5236:5236”
volumes:
– master-data:/dm/data
– master-log:/dm/log
– ./init-master.sql:/dm/init.sql
environment:
– DM_PASSWORD=SYSDBA
networks:
– dm-network
restart: always
command: [“/bin/bash”, “-c”, “dmserver /dm/data/DAMENG/dm.ini && disql SYSDBA/SYSDBA @/dm/init.sql”]
dm-slave:
image: dameng/dm8:latest
container_name: dm-slave
ports:
– “5237:5236”
volumes:
– slave-data:/dm/data
– slave-log:/dm/log
– ./init-slave.sql:/dm/init.sql
environment:
– DM_PASSWORD=SYSDBA
networks:
– dm-network
restart: always
depends_on:
– dm-master
command: [“/bin/bash”, “-c”, “dmserver /dm/data/DAMENG/dm.ini && disql SYSDBA/SYSDBA @/dm/init.sql”]
volumes:
master-data:
master-log:
slave-data:
slave-log:
networks:
dm-network:
driver: bridge

# init-master.sql
— 主库初始化脚本
— from:www.itpux.com.qq113257174.wx:itpux-com
— web: `http://www.fgedu.net.cn`
— 创建表空间
create tablespace fgedutbs datafile ‘/dm/data/DAMENG/fgedutbs.dbf’ size 1000M autoextend on next 100M maxsize 20480M;
— 创建用户
create user fgedu identified by “fgedu123” default tablespace fgedutbs;
grant dba to fgedu;
— 启用归档
alter database mount;
alter database add archivelog ‘type=local,dest=/dm/log/arch,file_size=128,space_limit=0’;
alter database archivelog;
alter database open;
— 配置主库
alter system set ‘ARCH_INI’ = 1 both;
alter system set ‘ALTER_MODE_STATUS’ = 0 both;
alter system set ‘ENABLE_OFFLINE_TS’ = 2 both;
— 创建复制用户
create user rep identified by “rep123”;
grant public,resource,replicate to rep;

# init-slave.sql
— 从库初始化脚本
— from:www.itpux.com.qq113257174.wx:itpux-com
— web: `http://www.fgedu.net.cn`
— 创建表空间
create tablespace fgedutbs datafile ‘/dm/data/DAMENG/fgedutbs.dbf’ size 1000M autoextend on next 100M maxsize 20480M;
— 创建用户
create user fgedu identified by “fgedu123” default tablespace fgedutbs;
grant dba to fgedu;
— 启用归档
alter database mount;
alter database add archivelog ‘type=local,dest=/dm/log/arch,file_size=128,space_limit=0’;
alter database archivelog;
alter database open;
— 配置从库
alter system set ‘ARCH_INI’ = 1 both;
alter system set ‘ALTER_MODE_STATUS’ = 0 both;
alter system set ‘ENABLE_OFFLINE_TS’ = 2 both;
— 配置主从复制
alter database standby;
alter system set ‘SRV_MGR_PORT’ = 5236 both;
alter system set ‘MAL_INI’ = 1 both;
alter system set ‘RLOG_SEND_APPLY_MON’ = 60 both;

# docker-compose.yml
version: ‘3.8’
services:
dm-master:
# …
networks:
dm-network:
ipv4_address: 172.20.0.2
dm-slave:
# …
networks:
dm-network:
ipv4_address: 172.20.0.3
networks:
dm-network:
driver: bridge
ipam:
config:
– subnet: 172.20.0.0/16
gateway: 172.20.0.1

# 1. 集群状态管理
– 查看集群状态
$ docker-compose ps
– 查看容器日志
$ docker-compose logs -f
– 查看容器详细信息
$ docker inspect dm-master
– 查看容器资源使用情况
$ docker stats dm-master dm-slave
# 2. 集群操作
– 启动集群
$ docker-compose up -d
– 停止集群
$ docker-compose down
– 重启集群
$ docker-compose restart
– 扩展服务
$ docker-compose up -d –scale dm-slave=2
# 3. 集群维护
– 进入容器
$ docker exec -it dm-master bash
– 备份数据
$ docker exec dm-master dmrman backup database ‘/dm/data/DAMENG/dm.ini’ full backupset ‘/dm/backup/full’
– 恢复数据
$ docker exec dm-master dmrman restore database ‘/dm/data/DAMENG/dm.ini’ from backupset ‘/dm/backup/full’
– 监控主从同步
$ docker exec dm-master disql SYSDBA/SYSDBA
SQL> select * from v$dm_arch_apply_status;
# 4. 集群升级
– 更新Docker镜像
$ docker pull dameng/dm8:latest
– 重新部署集群
$ docker-compose down
$ docker-compose up -d
# 5. 集群故障处理
– 主库故障
$ docker-compose restart dm-master
– 从库故障
$ docker-compose restart dm-slave
– 网络故障
$ docker network inspect dm-network