主库:
IP 192.168.171.8
操作系统版本 Red Hat Enterprise Linux Server release 7.5 (Maipo)
数据库版本 DM Database Server 64 V8 4-2-98-21.12.16-153423-10040-SEC
SELINUX DISABLED
防火墙 关闭
备库:
IP 192.168.171.23
操作系统版本 Red Hat Enterprise Linux Server release 7.5 (Maipo)
数据库版本 DM Database Server 64 V8 4-2-98-21.12.16-153423-10040-SEC
SELINUX DISABLED
防火墙 关闭
主库修改MAL_INI为1
[dmdba@yeshuo ~]$ cat /dmdata/dmdb/dm.ini |grep MAL_INI
MAL_INI = 1 #dmmal.ini
备库修改MAL_INI为1
[dmdba@dem ~]$ cat /dmdata/dmdb/dm.ini |grep MAL_INI
MAL_INI = 1 #dmmal.ini
主备库DMMAL.INI配置文件内容一致如下(实例名要不一致):
[dmdba@dem ~]$ cat /dmdata/dmdb/dmmal.ini
[MAL_INST1]
MAL_INST_NAME = DMDB
MAL_HOST = 192.168.171.8
MAL_PORT = 5251
MAL_INST_HOST = 192.168.171.8
MAL_INST_PORT = 5236
[MAL_INST2]
MAL_INST_NAME = DMDB2
MAL_HOST = 192.168.171.23
MAL_PORT = 5250
MAL_INST_HOST = 192.168.171.23
MAL_INST_PORT = 5236
主库重启:
[dmdba@yeshuo ~]$ DmServicedmdb restart
Stopping DmServicedmdb: [ OK ]
Starting DmServicedmdb: [ OK ]
备库重启:
[dmdba@dem ~]$ DmServicedmdb restart
Stopping DmServicedmdb: [ OK ]
Starting DmServicedmdb: [ OK ]
测试连通性:
测试连通性:
文章
阅读量
获赞