配置config.json,用于从一个库读数据写入到另外一个库
{
"job": {
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "123456",
"column": ["*"],
"connection": [
{
"table": [
"t_student"
],
"jdbcUrl": [
"jdbc:mysql://127.0.0.1:3306/school?useUnicode=true&characterEncoding=utf-8"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "123456",
"column": ["*"],
"session": [
"set session sql_mode='ANSI'"
],
"preSql": [
"delete from t_student"
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://127.0.0.1:3306/school_shanghai?useUnicode=true&characterEncoding=utf-8",
"table": [
"t_student"
]
}
]
}
}
}
],
"setting": {
"speed": {
"channel": 5
}
}
}
}