[Question][实时采集] binlog 实时同步到 mysql 报错

[caiyuyux]

Search before asking

• [X] I had searched in the issues and found no similar question.

• [X] I had googled my question but i didn't get any help.

• [X] I had read the documentation: ChunJun doc but it didn't help me.

Description

如题

脚本如下

{
  "job": {
    "content": [
      {
        "reader": {
          "parameter": {
            "password": "myxxx123",
            "port": 3306,
            "cat": "insert,update,delete",
            "host": "192.168.1.97",
            "jdbcUrl": "jdbc:mysql://192.168.1.97:3306/share_data",
            "start": {},
            "pavingData": false,
            "table": [
              "grd_grid_12"
            ],
            "username": "root"
          },
          "name": "binlogreader"
        },
        "writer": {
          "parameter": {
            "mode": "update",
            "postSql": [],
            "password": "mysqxxx23",
            "column": [
              {
                "name": "id",
                "type": "VARCHAR",
                "key": "id"
              }
            ],
            "connection": [
              {
                "jdbcUrl": "jdbc:mysql://192.168.1.97:3306/share_data",
                "table": [
                  "grd_grid_13"
                ]
              }
            ],
            "preSql": [
              ""
            ],
            "username": "root"
          },
          "name": "mysqlwriter"
        }
      }
    ],
    "setting": {
      "speed": {
        "channel": 1,
        "readerChannel": 1,
        "writerChannel": 1,
        "bytes": -1048576
      },
      "restore": {
        "isRestore": false,
        "isStream": false
      }
    }
  }
}

Code of Conduct

• [X] I agree to follow this project's Code of Conduct