Seatunnel从postgresql同步到mysql
任务场景:离线批量同步。顾名思意,离线批量同步需要用户定义好SeaTunnel JobConfig,选择批处理模式,作业启动后开始同步数据,当数据同步完成后作业完成退出。
配置文件如下:
env {
execution.parallelism = 2
job.mode = "BATCH"
checkpoint.interval = 10000
}
source {
Jdbc {
url = "jdbc:postgresql://IP:5432/bigDataTest"
driver = "org.postgresql.Driver"
connection_check_timeout_sec = 100
user = "***"
password = "***"
partition_column = "srid"
partition_num = 10
fetch_size = 10000
query = "select srid,auth_name,auth_srid,srtext,proj4text from public.spatial_ref_sys"
}
}
sink {
jdbc {
url = "jdbc