注册

DM8使用DMHS工具同步MYSQL8数据,目的端EXE[ERROR]: table .DMHS.dbtest1 do not exist in dest

DM_12128 2024/04/07 524 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:CentOS7
【CPU】:AMD
【问题描述】*:DM8使用DMHS工具同步MYSQL8数据,数据不同步,目的端EXE[ERROR]: table .DMHS.dbtest1 do not exist in dest,按理说在执行copy 0 "sch.name='my_db'" DICT|LSN|CREATE|INSERT|INDEX|THREAD|4,应该会创建table .DMHS.dbtest1表吧,是配置哪里出了问题吗?

mysql的dmhs.hs配置文件如下:

<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>
   <base>
       <lang>en</lang>
       <mgr_port>5345</mgr_port>
       <name>MYSQL_SRC</name>
       <ckpt_interval>60</ckpt_interval>
       <siteid>12</siteid>
       <version>2.0</version>
   </base>
   <cpt>
       <enable>1</enable>
       <name>cpt</name>
       <db_type>MYSQL</db_type>
       <db_server>172.20.10.201</db_server>   
       <db_port>3306</db_port>
       <db_name>my_db</db_name>
       <db_user>hstest</db_user>     
       <db_pwd>abc123</db_pwd>
       <ddl_mask> op:obj</ddl_mask>
       <idle_time>300</idle_time>  
       <driver>MySQL ODBC Driver</driver>
       <char_code>PG_UTF8</char_code>
       <parse_thr>4</parse_thr>
       <io_threads>4</io_threads>     
       <arch>
           <clear_flag>0</clear_flag>
           <clear_interval>600</clear_interval>
       </arch>
       <send>
           <ip>172.20.10.200</ip>
           <mgr_port>5345</mgr_port>
           <data_port>5346</data_port>
           <trigger>1</trigger>
           <constraint>1</constraint>
           <identity>1</identity>
           <filter>
               <enable>
                   <item> my_db.*</item>
               </enable>
               <disable>
               </disable>
           </filter>
           <map>
               <item> my_db.*==DMHS.*</item>
           </map>
       </send>
   </cpt>
</dmhs>

dm的dmhs.hs的配置文件如下:

<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>    
	<base>        
		<lang>en</lang>        
		<version>2.0</version>        
		<mgr_port>5345</mgr_port>        
		<chk_interval>3</chk_interval>        
		<ckpt_interval>60</ckpt_interval>        
		<siteid>2</siteid>    
	</base>    
	<exec>        
		<recv>            
			<mgr_port>5345</mgr_port>  <!-- 接收管理端口-->            
			<data_port>5346</data_port>  <!-- 接收数据端口-->        
		</recv>        
		<db_type>DM8</db_type>        
		<db_server>172.20.10.200</db_server>        
		<db_user>DMHS</db_user>   <!-- 数据库用户名-->        
		<db_pwd>Hn@dameng123</db_pwd>        
		<db_port>5236</db_port>        
		<exec_policy>2</exec_policy>        
		<char_code>PG_UTF8</char_code>
		<exec_thr>16</exec_thr>          <!--执行线程参数-->               
		<seq_sync_mode>1</seq_sync_mode>   <!--序列同步参数-->        
		<trxid_tables>5</trxid_tables>        
		<save_point_times>4294967294</save_point_times>        
		<clear_trx_file>1</clear_trx_file>        
		<trx_max_file>5</trx_max_file>      
	</exec>
</dmhs>

mysql端同步操作如下:

[root@mysql8019 bin]# ./dmhs_console 
DMHS console tool: V4.3.00-Build(2022.11.28-119352trunc)_64_2211_sp6
Copyright (c) 2020, DMHS. All rights reserved.
Type ? or "help" for help, type "quit" to quit console.

Connected to DMHS: 127.0.0.1:5345
execute success
Dameng HS Server V4.3.00-Build(2022.11.28-119352trunc)_64_2211_sp6

DMHS>clear exec lsn
execute success

DMHS>copy 0 "sch.name='my_db'" DICT|LSN|CREATE|INSERT|INDEX|THREAD|4
CSL[WARN]: Detect the LSN mask, the mask will be ignored in the log is less than the current LSN all operations, please confirm whether to continue?(Y/N)
y
copy mask is : |CREATE|INSERT|THREAD|INDEX|TABLE|DICT|LSN|PARTITION|OBJID|REP
execute finish, please look up log file of exec module to check data load result

DMHS>start cpt
回答 0
暂无回答
扫一扫
联系客服