LiJie20190102 commented on issue #10218:
URL: https://github.com/apache/seatunnel/issues/10218#issuecomment-3677810634
1. If the `base-url` is the same, you can use a `MySQL-CDC` as follows:
```
source {
MySQL-CDC {
base-url="jdbc:mysql://localhost:3306/test_source"
password="xxxx"
"startup.mode"=initial
#"exactly_once"=true
"plugin_output"="1996846717407989760"
table-names=[
"test_source3.test1219",
"test_source3.test1220",
"test_source4.test1219"
]
username=root
}
}
```
2. Usually, in the CDC scenario, I think no field operations are required,
that is, no transform is needed, unless you have special requirements. You can
test it out
3. The sink side can also use one, which will create multiple tables on the
source side in a certain library, as shown below：
```
sink {
jdbc {
url = "jdbc:mysql://localhost3:3306/test_sink"
driver = "com.mysql.cj.jdbc.Driver"
user = "root"
password = "xxxx"
database = test_sink
generate_sink_sql = true
}
}
```
--
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]
