脚本任务
{
"job": {
"setting": {
"speed": {
"channel": 1
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "****",
"column": [
"*"
],
"splitPk": "id",
"connection": [
{
"table": [
"xxx"
],
"jdbcUrl": [
"jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=UTF-8&useSSL=false"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "zhenwu",
"password": "Fiber@123456",
"column": [
"*"
],
"session": [
"set session sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"
],
"preSql": [
"TRUNCATE XXX"
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://XXX:3306/XXX?useUnicode=true&characterEncoding=UTF-8&useSSL=false",
"table": [
"XXX"
]
}
]
}
}
}
]
}
}