datax数据同步更新策略-以mysql2mysql为例

全量抽取策略

{
   
    "job": {
   
        "setting": {
   
            "speed": {
   
                "channel": 3
            },
            "errorLimit": {
   
                "record": 0,
                "percentage": 0.02
            }
        },
        "content": [{
   
            "reader": {
   
                "name": "mysqlreader",
                "parameter": {
   
                    "username": "root",
                    "password": "APIB9hRP",
                    "column": [
                        "id",
                        "name",
			"age",
			"address",
			"salary"
                    ],
                    "splitPk": "id",
                    "connection": [{
   
                        "table": [
                            "company"
                        ],
                        "jdbcUrl": [
                            "jdbc:mysql://localhost:3306/datax?serverTimezone=UTC"
                        ]
                    }]
                }
            },
            "writer": {
   
                "name": "mysqlwriter"