规划
主机 192.168.100.112
备机 192.168.100.114
监视器 192.168.100.114
数据库安装路径:/home/dmdba/dmdbms
数据库实例路径:/home/dmdba/dmdbms/data
搭建前关闭防火墙
systemctl stop firewalld 禁用防火墙
systemctl disable firewalld 停止并禁用开机启动
systemctl start firewalld 启动防火墙
systemctl enable firewalld 设置开机启动
systemctl status firewalld 查看防火墙状态
1.初始化实例(主机备机相同操作)
cd /home/dmdba/dmdbms/bin
./dminit path=/home/dmdba/dmdbms/data/
2.启停数据库一次
./dmserver /home/dmdba/dmdbms/data/DAMENG/dm.ini
exit
出现SYSTEM IS READY后输入exit关闭数据库
二.脱机备份
1.主机上备份:
./dmrman ctlstmt="backup database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' full to backup01 backupset '/home/dmdba/backup01/'"
2.发送给备机:
scp -r /home/dmdba/backup01/ dmdba@192.168.100.114:/home/dmdba
3.备机上还原
./dmrman ctlstmt="restore database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup01'"
4.备机上恢复
./dmrman ctlstmt="recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup01'"
5.备机上更新
./dmrman ctlstmt="recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' update db_magic"
三.配置主库
修改dm.ini文件参数,创建dmmal.ini,dmarch.ini,dmwatcher.ini文件
1.dm.ini文件
INSTANCE_NAME=DM01
ARCH_INI=1
MAL_INI=1
ALTER_MODE_STATUS= 0
ENABLE_OFFLINE_TS = 2
2.dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DM01
MAL_HOST = 192.168.100.112
MAL_PORT = 61141
MAL_INST_HOST = 192.168.100.112
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 33141
[MAL_INST2]
MAL_INST_NAME = DM02
MAL_HOST = 192.168.100.114
MAL_PORT = 61142
MAL_INST_HOST = 192.168.100.114
MAL_INST_PORT = 5236
MAL_DW_PORT = 52142
MAL_INST_DW_PORT = 33142
3.dmarch.ini
ARCH_WAIT_APPLY=1
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = DM02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmdbms/data/DAMENG/arch
ARCH_FILE_SIZE = 512
ARCH_SPACE_LIMIT = 10240
读写分离集群要求实时归档+事务一致性
4.dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /home/dmdba/dmdbms/data/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
将1,2,3,4发给备库
scp dm.ini dmmal.ini dmarch.ini dmwatcher.ini dmdba@192.168.100.114:/home/dmdba/dmdbms/data/DAMENG
配置备库
1.修改dm.ini
将INSTANCE_NAME设置为DM02
INSTANCE_NAME=DM02
2.修改dmarch.ini
将ARCH_DEST参数修改为主库的
ARCH_DEST = DM01
配置监视器
1.dmmonitor.ini
MON_DW_Confirm = 1
MON_LOG_PATH = /home/dmdba/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.100.112:52141
MON_DW_IP = 192.168.100.114:52142
四.注册服务(root 用户下)
1.实例服务(主备库相同)
安装路径script/root目录下:
./dm_service_installer.sh -t dmserver -m mount -dm_ini /home/dmdba/dmdbms/data/DAMENG/dm.ini -p DM
2.watcher服务(主备库相同
安装路径script/root目录下:
./dm_service_installer.sh -t dmwatcher -watcher_ini /home/dmdba/dmdbms/data/DAMENG/dmwatcher.ini -p DM
3.监视器服务(备库)
安装路径script/root目录下:
./dm_service_installer.sh -t dmmonitor -monitor_ini /home/dmdba/dmdbms/data/DAMENG/dmmonitor.ini -p DM
五.配置OGUID
主库,启动服务,连接数据库,修改参数
./DmServiceDM start
./disql
sp_set_oguid(453331);
alter database primary;
备库,启动服务,连接数据库,修改参数
./DmServiceDM start
./disql
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(453331);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
六.启动集群
主备库启动watcher服务:
./DmWatcherServiceDM start
备库启动监视器:
./DmMonitorServiceDM start
主库
备库
进入log下查看dmmonitor***.log
cd /home/dmdba/log
tail -100f dmmonitor***.log