wcc1433 commented on issue #1560:
URL: https://github.com/apache/paimon/issues/1560#issuecomment-2705425581
+1,我碰到了一样的问题。通过 paimon flink action 进行 mysql 整库同步
环境:数据库:mysql 8.0,cdc:3.3,paimon:1.0.1,flink:1.20.1
启动命令:
./bin/flink run \
./paimon-flink-action-1.0.1.jar \
mysql_sync_database
--warehouse "oss://----------/paimon"
--database "ods_erp"
--mode combined
--type_mapping to-nullable,char-to-string,bigint-unsigned-to-bigint
--mysql_conf hostname=---------------------------
--mysql_conf username=--------
--mysql_conf password=-----------
--mysql_conf database-name=zx_erp
--mysql_conf server-time-zone=Asia/Shanghai
--mysql_conf scan.startup.mode=initial
--catalog_conf metastore=filesystem
--catalog_conf warehouse=oss://---------------/paimon
--catalog_conf fs.oss.endpoint=oss-cn-hangzhou-internal.aliyuncs.com
--catalog_conf fs.oss.accessKeyId=------------------------
--catalog_conf fs.oss.accessKeySecret=-----------------------
--table_conf bucket=1
--table_conf changelog-producer=input
--table_conf sink.parallelism=1./bin/flink run \
./paimon-flink-action-1.0.1.jar \
mysql_sync_database
--warehouse "oss://----------/paimon"
--database "ods_erp"
--mode combined
--type_mapping to-nullable,char-to-string,bigint-unsigned-to-bigint
--mysql_conf hostname=---------------------------
--mysql_conf username=--------
--mysql_conf password=-----------
--mysql_conf database-name=zx_erp
--mysql_conf server-time-zone=Asia/Shanghai
--mysql_conf scan.startup.mode=initial
--catalog_conf metastore=filesystem
--catalog_conf warehouse=oss://---------------/paimon
--catalog_conf fs.oss.endpoint=oss-cn-hangzhou-internal.aliyuncs.com
--catalog_conf fs.oss.accessKeyId=------------------------
--catalog_conf fs.oss.accessKeySecret=-----------------------
--table_conf bucket=1
--table_conf changelog-producer=input
--table_conf sink.parallelism=1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]