为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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
是否是新创建的表?是否配置DDL同步?
可以创建单独的链接同步该表看看