MariaDB Replication - Missing ^M Characters on Slave

Ask Question

Asked 3 years, 10 months ago

Modified 3 years, 10 months ago

Viewed 30 times

I've got a simple single master->slave replication setup with MIXED binlog format for mariadb 10.2.22-1 on RHEL7.

I believe I'm having an issue where '^M' characters in a longtext column are not being replicated to the slave.

I've checked the encoding matches on both databases (SHOW VARIABLES LIKE 'collat%' and SHOW VARIABLES LIKE 'char%').

Does anyone know what might be causing the slave to strip the '^M' character when the data is being replicated to the slave?

dbdemon

6,1614 gold badges18 silver badges37 bronze badges

asked Jul 30, 2019 at 6:20

32 bronze badges

Is one machine Windows and the other *nix?
– Vérace
Jul 30, 2019 at 9:49
Nope, both are *nix (RHEL7).
– TheOneWhoDoesItAll
Jul 31, 2019 at 4:50
Please provide SELECT HEX(col) ... on both the Master and Slave for some small row with a ^M that disappeared. What charset and collation are you using? For most, ^M is handled the same.
– Rick James
Jul 31, 2019 at 22:58

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.