DTStack / DTStack/chunjun

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

Open
#1,616 0 comments 1 reaction 0 assignees View on GitHub
question
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [X] I had searched in the [issues](https://github.com/DTStack/chunjun/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](https://dtstack.github.io/chunjun) but it didn't help me.

### Description

如题
image

脚本如下
```
{
"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](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.