- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
Hello.
The error message you're encountering, "Error 'Character set '#255' is not a compiled character set," suggests that there might be an issue with character set compatibility between your RDS Aurora MySQL and EC2 MySQL instances. This error typically occurs when the replication process encounters a character set that is not supported or recognized on the receiving end.
You can use the SHOW VARIABLES LIKE 'character_set%'; and SHOW VARIABLES LIKE 'collation%'; commands to check the character set and collation settings on both servers.
Double-check the binary log format and replication settings on both servers. Make sure they are set correctly. The binary log format should be set to ROW or MIXED for better compatibility.
Best regards, Andrii
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 3 anni fa
Thank you for the answer Andrii, regarding on the setup of both RDS and EC2 mysql, the binary log format is already set to MIXED and gtid_mode is set to ON. I ran this SHOW VARIABLES LIKE 'collation%'; command on both mysql and returns same results while the collation is kinda different. Should I set the same collation on both mysql? or this can be a compatibility issue? Any Idea?