@崔允 按照你的流程,结果最后一步执行后,报错了,一直没有解决
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1 ,SQL_MODE=concat(@@sql_mode, _utf8mb4 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') ': Variable 'sql_mode' can't be set to the value of 'NO_KEY_OPTIONS' (1231)
[2020/03/11 19:11:58] [error] canal.go:224 canal dump mysql err: exit status 2
[2020/03/11 19:11:58] [error] river.go:297 start canal err exit status 2
使用go-mysql-elasticsearch将mysql实时同步到es注意:mysql binlog必须是ROW模式 ,并且binlog_row_image必须为full要同步的mysql数据表必须包含主键,否则直接忽略不支持程序运行过程中修改...