Flink CDC 3.1.0 pipeline 多表合一、分库分表 Mysql写入Doris yaml

作者：码创造者 | 2024-07-03 10:03:46

踩

多表合一 yaml：


source:
  type: mysql
  hostname: 172.xxx.xxx.xxx
  port: 3306
  username: root
  password: xxx
  tables: sync_db.\.*
  server-id: 5400-5404
  server-time-zone: Asia/Shanghai
 
sink:
  type: doris
  fenodes: 172.xxx.xxx.xxx:8030
  username: root
  password: xxx
  table.create.properties.light_schema_change: true
 
route:
  - source-table: sync_db.\.*
    sink-table: sync_db.ods_sync_db
 
pipeline:
  name: Sync MySQL Database to Doris
  parallelism: 2

分库分表 yaml：


source:
  type: mysql
  hostname: 172.xxx.xxx.xxx
  port: 3306
  username: root
  password: xxx
  tables: sync_db.\.*
  server-id: 5400-5404
  server-time-zone: Asia/Shanghai
 
sink:
  type: doris
  fenodes: 172.xxx.xxx.xxx:8030
  username: root
  password: xxx
  table.create.properties.light_schema_change: true
 
route:
  - source-table: sync_db.teacher
    sink-table: syc.ods_teacher
  - source-table: sync_db.student
    sink-table: syc.ods_student
 
pipeline:
  name: Sync MySQL Database to Doris
  parallelism: 2

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/码创造者/article/detail/782721