DM8单机双向DMHS服务搭建

修改源端、目的端实例的服务器配置文件

1. dm.ini，主要修改参数如下：

[dmdba@localhost bin]# cat /opt/dmdata/DAMENG/dm.ini 
ARCH_INI = 1
RLOG_APPEND_LOGIC = 1 
FAST_COMMIT = 0（若不为0，则可能导致逻辑日志不全，而影响同步效果，DM8默认为0） 

2. 配置源端数据库归档模式

[dmdba@localhost bin]# cat /opt/dmdata/DAMENG/dmarch.ini 
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmarch #归档目录
ARCH_FILE_SIZE = 128 #归档文件大小，单位 MB
ARCH_SPACE_LIMIT = 0 #空间大小限制，0 表示不限制

3. 使用disql工具执行dmhs安装目录下的脚本

start /opt/dmhs/scripts/ddl_sql_dm8.sql

4. 执行安装命令
   

5. 源端配置dmhs.hs文件

<?xml version="1.0" encoding="utf-8"?>

<dmhs> 
  <base> 
    <lang>ch</lang>  
    <mgr_port>5345</mgr_port>  
    <chk_interval>2</chk_interval>  
    <siteid>1</siteid> 
  </base>  
  <recv> 
    <data_port>5346</data_port>  
    <exec> 
      <db_type>DM8</db_type>  
      <db_server>源端IP</db_server>  
      <db_user>SYSDBA</db_user>  
      <db_pwd>SYSDBA</db_pwd>  
      <db_port>5236</db_port>  
      <db_name/>  
      <exec_thr>4</exec_thr>  
      <exec_sql>512</exec_sql>  
      <exec_trx>5000</exec_trx>  
      <exec_rows>250</exec_rows>  
      <msg_col_size>3000</msg_col_size>  
      <exec_policy>0</exec_policy> 
    </exec> 
  </recv>  
  <cpt> 
    <db_type>DM8</db_type>  
    <db_server>源端IP</db_server>  
    <db_user>SYSDBA</db_user>  
    <db_pwd>SYSDBA</db_pwd>  
    <db_port/>  
    <idle_time>300</idle_time>  
    <ddl_mask>TABLE:INDEX:TRUNCATE:CREATE:DROP:ALTER</ddl_mask>  
    <parse_thr>1</parse_thr>  
    <arch> 
      <clear_interval>600</clear_interval>  
      <clear_flag>1</clear_flag>  
      <bak_dir/> 
    </arch>  
    <send> 
      <ip>目标端IP</ip>  
      <mgr_port>5345</mgr_port>  
      <data_port>5346</data_port>  
      <level>0</level>  
      <trigger>0</trigger>  
      <constraint>0</constraint>  
      <identity>0</identity>  
      <net_turns>0</net_turns>  
      <filter> 
        <enable> 
          <item>SYSDBA.*</item> 
        </enable>  
        <disable> 
          <item/> 
        </disable> 
      </filter>  
      <map> 
        <item>SYSDBA.*==SYSDBA.*</item> 
      </map> 
    </send> 
  </cpt> 
</dmhs>

6. 目的端配置dmhs.hs文件

<?xml version="1.0" encoding="utf-8"?>

<dmhs> 
  <base> 
    <lang>ch</lang>  
    <mgr_port>5345</mgr_port>  
    <chk_interval>2</chk_interval>  
    <siteid>2</siteid> 
  </base>  
  <recv> 
    <data_port>5346</data_port>  
    <exec> 
      <db_type>DM8</db_type>  
      <db_server>目标端IP</db_server>  
      <db_user>SYSDBA</db_user>  
      <db_pwd>SYSDBA</db_pwd>  
      <db_port>5236</db_port>  
      <db_name/>  
      <exec_thr>4</exec_thr>  
      <exec_sql>512</exec_sql>  
      <exec_trx>5000</exec_trx>  
      <exec_rows>250</exec_rows>  
      <msg_col_size>3000</msg_col_size>  
      <exec_policy>1</exec_policy> 
    </exec> 
  </recv>  
  <cpt> 
    <db_type>DM8</db_type>  
    <db_server>目标端IP</db_server>  
    <db_user>SYSDBA</db_user>  
    <db_pwd>SYSDBA</db_pwd>  
    <db_port/>  
    <idle_time>300</idle_time>  
    <ddl_mask/>  
    <parse_thr>1</parse_thr>  
    <arch> 
      <clear_interval>600</clear_interval>  
      <clear_flag>1</clear_flag>  
      <bak_dir/> 
    </arch>  
    <send> 
      <ip>源端IP</ip>  
      <mgr_port>5345</mgr_port>  
      <data_port>5346</data_port>  
      <level>0</level>  
      <trigger>0</trigger>  
      <constraint>0</constraint>  
      <identity>0</identity>  
      <net_turns>0</net_turns>  
      <filter> 
        <enable> 
          <item>SYSDBA.*</item> 
        </enable>  
        <disable> 
          <item/> 
        </disable> 
      </filter>  
      <map> 
        <item>SYSDBA.*==SYSDBA.*</item> 
      </map> 
    </send> 
  </cpt> 
</dmhs>

7. 调起监控窗口

[dmdba@localhost bin]$ ./dmhs_server dmhs.hs

8. 目的端启动dmhs服务

[dmdba@localhost  bin]$  ./dmhs_console
DMHS> connect
DMHS> start exec

9. 源端启动dmhs服务

[dmdba@localhost  bin]$  ./dmhs_console
DMHS> connect
DMHS> copy 0 “sch.name=’xxx’” dict

10. 下图以‘DMHR’为例
    

11. 同步表结构和数据

DMHS> copy 0 “sch.name=’xxx’” create|insert

达梦社区