logo
社区首页 / 全域数据集成平台 / 问题详情
标题
mysql CDC同步监听,采用数据库直接同步,目标库没更新数据库,2.0以前版本可以,看日志无报错
0
用户头像
楼主:1530607****
主题:4     回复:3     获赞:0 注册日期:2023-06-13

mysql CDC同步监听,采用数据库直接同步,目标库没更新数据库,2.0以前版本可以,看日志无报错

---------------------------------------------------
签名:
共2回答
0
用户头像
回答者: 1530607****
获赞:0 注册于:2023-06-13 回答于 2023-06-29 16:43:52 #1

99-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702a7cbdf:1-83576794 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Using first available positions for new GTID channels 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Relevant GTID set available on server: 17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4a1 2-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702a7cbdf:1-83576794 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Final merged GTID set to use when connecting to MySQL: 17550744-9258-11ed-9f4b-485702a7cbef:1-58662 694,597a8905-4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702a7cbdf:1-83573313 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Registering binlog reader with GTID set: 17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4 a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702a7cbdf:1-83573313 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Skip 0 events on streaming start 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Skip 0 rows on streaming start 2023-06-29 16:19:07.612 INFO 78856 --- [rce-coordinator] io.debezium.util.Threads : Creating thread debezium-mysqlconnector-xxx-sync_cdc-binlog-client 2023-06-29 16:19:07.628 INFO 78856 --- [0.0.191.39:3306] io.debezium.util.Threads : Creating thread debezium-mysqlconnector-xxx-sync_cdc-binlog-client 29-Jun-2023 16:19:07.643 信息 [blc-140.0.191.39:3306] com.github.shyiko.mysql.binlog.BinaryLogClient.connect Connected to 140.0.191.39:3306 at 17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905- 4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702a7cbdf:1-83573313 (sid:5979, cid:6332983) 2023-06-29 16:19:07.643 INFO 78856 --- [0.0.191.39:3306] i.d.c.m.MySqlStreamingChangeEventSource : Connected to MySQL binlog at 140.0.191.39:3306, starting at MySqlOffsetContext [sourceInfoSchema=Sc hema{io.debezium.connector.mysql.Source:STRUCT}, sourceInfo=SourceInfo [currentGtid=null, currentBinlogFilename=mysql-bin.000324, currentBinlogPosition=281943306, currentRowNumber=0, serverId=0, sourc eTime=null, threadId=-1, currentQuery=null, tableIds=[], databaseName=null], snapshotCompleted=false, transactionContext=TransactionContext [currentTransactionId=null, perTableEventCount={}, totalEven tCount=0], restartGtidSet=17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fdc-485702 a7cbdf:1-83573313, currentGtidSet=17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fd c-485702a7cbdf:1-83573313, restartBinlogFilename=mysql-bin.000324, restartBinlogPosition=281943306, restartRowsToSkip=0, restartEventsToSkip=0, currentEventLengthInBytes=0, inTransaction=false, transa ctionId=null, incrementalSnapshotContext =IncrementalSnapshotContext [windowOpened=false, chunkEndPosition=null, dataCollectionsToSnapshot=[], lastEventKeySent=null, maximumKey=null]] 2023-06-29 16:19:07.643 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Waiting for keepalive thread to start 2023-06-29 16:19:07.643 INFO 78856 --- [0.0.191.39:3306] io.debezium.util.Threads : Creating thread debezium-mysqlconnector-xxx-sync_cdc-binlog-client 2023-06-29 16:19:07.768 INFO 78856 --- [rce-coordinator] i.d.c.m.MySqlStreamingChangeEventSource : Keepalive thread is running 2023-06-29 16:19:11.706 INFO 78856 --- [ xxx-sync] i.d.connector.common.BaseSourceTask : 1 records sent during previous 00:00:05.203, last recorded offset: {transaction_id=null, file=mysql -bin.000324, pos=289058200, gtids=17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fd c-485702a7cbdf:1-83576839, server_id=1546906770} 2023-06-29 16:19:23.065 INFO 78856 --- [ xxx-sync] i.d.connector.common.BaseSourceTask : 1 records sent during previous 00:00:11.359, last recorded offset: {transaction_id=null, file=mysql -bin.000324, pos=289526084, gtids=17550744-9258-11ed-9f4b-485702a7cbef:1-58662694,597a8905-4a12-11ed-a499-485702a7cbdf:1-151465687,5e9eeb5a-36f8-11ed-aebd-702084fb4b7a:1-4612438,7fb415aa-da63-11ed-8fd c-485702a7cbdf:1-83577056, server_id=1546906770}

---------------------------------------------------
签名:
0
用户头像
回答者: 1530607****
获赞:0 注册于:2023-06-13 回答于 2023-06-30 14:57:18 #2

可以了,库要手动选,带库名

---------------------------------------------------
签名: