mysql主从同步异常一例

Posted 2021-07-22 by wukaiqiang; tagged with none

主从同步报错：column 0 of talbe 'XXX' cannot be converted from type 'varchar(120(bytes))' to type 'varchar(160(bytes)) utf8mb4
检查发现主库字符集是utf8，从库字符集是utf8mb4，因为从库采用逻辑恢复，创建数据库时指定的字符集类型错误导致。