Datax mysql8.x to mysql8.x json测试样例
{ "job": { "setting": { "speed": { "channel": 1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "root", "password": "root", "column": [ "id", "name","content" ,"createdate"], "splitPk": "id", "connection": [ { "table": [ "t_user_info" ], "jdbcUrl": [ "jdbc:mysql://192.168.8.248:3306/sourcedb?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC" ] } ] } }, "writer": { "name": "mysqlwriter", "parameter": { "writeMode": "insert", "username": "root", "password": "root", "column": [ "id", "name","content","createdate"], "session": [ "set session sql_mode='ANSI'" ], "preSql": [ "delete from t_user_info" ], "connection": [ { "jdbcUrl": "jdbc:mysql://192.168.8.248:3306/targetdb?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC", "table": [ "t_user_info" ] } ] } } } ] } }