【无标题】

最新推荐文章于 2025-12-19 15:39:34 发布

原创最新推荐文章于 2025-12-19 15:39:34 发布 · 457 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #servlet #html

datax 专栏收录该内容

2 篇文章

订阅专栏

{
"job": {
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "123"
"column": ["*"],
"splitPk": "id",
"connection": [
{
"jdbcUrl": [
"jdbc:mysql://读取端IP:3306/testdatax?useUnicode=true&characterEncoding=utf8"
],
"table": ["user1w"]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"column": ["*"],
"connection": [
{
"jdbcUrl": "jdbc:mysql://写入端IP:3306/testdatax?useUnicode=true&characterEncoding=utf8",
"table": ["user1w"]
}
],
"password": "123",
"preSql": [
"truncate user1w"
],
"session": [
"set session sql_mode='ANSI'"
],
"username": "root",
"writeMode": "insert"
}
}
}
],
"setting": {
"speed": {
"channel": "5"
}
}
}
}

{
"job":{
"content":[
{
"reader": {
"name": "oraclereader",
"parameter": {
"username": "user",
"password": "passworkd",
"column": [
"c1",
"c2"
],
"connection": [
{
"table": [
"tableName"
],
"jdbcUrl": [
"jdbc:oracle:thin:@//ip:port/dbName"
]
}
]
}
},
"writer": {
"name": "oceanbasev10writer",
"parameter": {
"obWriteMode": "insert",
"username": "user",
"password": "password",
"writerThreadCount": 16,
"batchSize": 512,
"column": [
"*"
],
"connection": [
{
"jdbcUrl": "||_dsc_ob10_dsc_||ob1ClusterName:tenantName||_dsc_ob10_dsc_||jdbc:oceanbase://obproxyIpAddress:port/dbName?useUnicode=true&characterEncoding=utf-8",
"table": [
"tabName"
]
}
]
}
}
}
],
"setting":{
"errorLimit":{
"record":0
},
"jvmOption":"-Xms8092m -Xmx8092m",
"speed":{
"channel":16
}
}
}
}