{ "job": { "setting": { "speed": { "channel": 4 }, "errorLimit": { "record": 0, "percentage": 0.1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "root", "password": "xxxxxx", "column": [ "*" ], "connection": [ { "table": [ "c1" ], "jdbcUrl": ["jdbc:mysql://xx.xxx.xx:3306/qqq?useUnicode=true&characterEncoding=utf8"] } ] } }, "writer": { "name": "oceanbasev10writer", "parameter": { "obWriteMode": "insert", "column": [ "*" ], "preSql": [ "truncate table tb_students_info" ], "connection": [ { "jdbcUrl": "||_dsc_ob10_dsc_||xxxxx:xxxx||_dsc_ob10_dsc_||jdbc:oceanbase://xx.xxx.xxx:2883/qqq?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true", "table": [ "c1" ] } ], "username": "root", "password":"xxxxxxx", "writerThreadCount":10, "batchSize": 1000, "memstoreThreshold": "0.9" } } } ] } }