@崔允 按照你的流程,結(jié)果最后一步執(zhí)行后,報(bào)錯(cuò)了,一直沒有解決
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實(shí)時(shí)同步到es注意:mysql binlog必須是ROW模式 ,并且binlog_row_image必須為full要同步的mysql數(shù)據(jù)表必須包含主鍵,否則直接忽略不支持程序運(yùn)行過程中修改...