Comments - Setting Up Replication
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I have added a slave of version mariadb 10.2.14 to a master of version mysql 5.5.20. i have table with character set latin1 on master and same table with utf4mb4 on slave.
As per my knowledge replication between different character set is not allowed. But i am able to replicate. I got below conversion error. Last_Errno: 1677 Last_Error: Column 0 of table 'xx.xx' cannot be converted from type 'varchar(100)' to type 'varchar(100)'
but when i used slave_type_conversions=All_NON_lossy on slave, everything is working fine. Using mixed binlog format .
Will you please help how replication is possible with different char set and how my error got resolve when setting 'slave_type_conversions' is only effective in case of row based logging?
I guess the safest way to go is to upgrade your master server to 10.2. I wonder if replication between 5.5 and 10.2 actually works, you say it does, but you face a problem that could arise from the version difference.
Thanks for the response. We are planning to upgrade same as you suggested, But i am still wondering how option "slave_type_conversions=All_NON_lossy" worked, when i am using mixed binary logging. Replication broken in case of truncate table which generated a statement type binary log.Please help in understanding the same.