Return to Answer

formatting, update link, add some explanation

edit approved Feb 4, 2022 at 1:35

In your specific case setting 'slave_conversion_type=ALL_NON_LOSSY'slave_conversion_type=ALL_NON_LOSSY would help. Execute Execute these commands on the slave:

STOP SLAVE; SET GLOBAL SLAVE_TYPE_CONVERSIONS=ALL_NON_LOSSY; START SLAVE; SHOW SLAVE STATUS\G

STOP SLAVE; SET GLOBAL SLAVE_TYPE_CONVERSIONS=ALL_NON_LOSSY; START SLAVE; SHOW SLAVE STATUS\G

For more information read here:From https://dev.mysql.com/doc/mysql-replication-excerpt/5.5/en/replication-features-different-data-types.html the documentation:

This mode permits conversions that do not require truncation or other special handling of the source value; that is, it permits conversions where the target type has a wider range than the source type.

In your specific case setting 'slave_conversion_type=ALL_NON_LOSSY' would help. Execute on slave:

STOP SLAVE; SET GLOBAL SLAVE_TYPE_CONVERSIONS=ALL_NON_LOSSY; START SLAVE; SHOW SLAVE STATUS\G

For more information read here: https://dev.mysql.com/doc/mysql-replication-excerpt/5.5/en/replication-features-different-data-types.html

In your specific case setting slave_conversion_type=ALL_NON_LOSSY would help. Execute these commands on the slave:

STOP SLAVE; SET GLOBAL SLAVE_TYPE_CONVERSIONS=ALL_NON_LOSSY; START SLAVE; SHOW SLAVE STATUS\G

From the documentation:

This mode permits conversions that do not require truncation or other special handling of the source value; that is, it permits conversions where the target type has a wider range than the source type.