达梦8守护集群搭建操作步骤:
一、环境配置信息:
主机IP 实例名 MAL监听TCP端口 对外服务IP地址 实例的对外服务端口 例对应的守护进程监听TCP连接的端口 实例监听守护进程TCP连接的端口
MAL_HOST MAL_INST_NAME MAL_PORT MAL_INST_HOST MAL_INST_PORT MAL_DW_PORT MAL_INST_DW_PORT
192.168.1.110 GRP1_RW_01 61141 192.168.1.110 5236 52141 33141
192.168.1.111 GRP1_RW_02 61142 192.168.1.111 5236 52142 33142
二、配置步骤
1.主备库初始化数据库:
主库:
[dmdba@localhost dm8]$ dminit path='/dm8/data/' instance_name=GRP1_RW_01 db_name=DM CASE_SENSITIVE=Y EXTENT_SIZE=32 PAGE_SIZE=32 LOG_SIZE=256 PORT_NUM=5236
[root@localhost ~]# cd /dm8/script/root/
[root@localhost root]# ./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DM/dm.ini -p DM
[root@localhost root]# systemctl start DmServiceDM.service
[root@localhost root]# systemctl enable DmServiceDM.service
备库:
[dmdba@localhost dm8]$ dminit path='/dm8/data/' instance_name=GRP1_RW_02 db_name=DM CASE_SENSITIVE=Y EXTENT_SIZE=32 PAGE_SIZE=32 LOG_SIZE=256 PORT_NUM=5236
[root@localhost ~]# cd /dm8/script/root/
[root@localhost root]# ./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DM/dm.ini -p DM
[root@localhost root]# systemctl start DmServiceDM.service
[root@localhost root]# systemctl enable DmServiceDM.service
2.备份还原(主库执行数据备份,先关闭实例,再执行备份。)
1)主备库关闭数据库
[root@localhost root]# systemctl stop DmServiceDM.service
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost ~]$ ./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DM/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/'"