- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
HI there,
The below error message is usually observed when the charset and collation are not matching between the source and the replica server.
Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file;,Error_code: 22
Make sure that the collation and charset matches in both replica and the source instance using below queries:
SHOW VARIABLES LIKE '%character_set%'; SHOW VARIABLES LIKE '%collation%';
Also make sure that the replica instance on EC2 instance is running on same major version (version 5.7).
Use the parameter group to make any modification to the parameters in the source RDS MySQL instance and update the my.cnf file on EC2 mysql instance to make any changes to the parameters in your replica instance.
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa