- Newest
- Most votes
- Most comments
I have the same (or similar) issue. The interesting part here is that WE ARE ABLE to run native mysql replication from aurora with mysql 5.7 to rds with mysql 8.0.36, but we are unable to replicate from aurora 5.7 to aurora serverless with mysql 8 and even from the rds with mysql 8.0.36 to aurora serverless with mysql 8. we're getting the same error message ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation 'regexp_like'
while running mysql.rds_set_external_master
. any ideas what could cause aurora replication to not work?
whaat is interesting here is that none of the tables/columns/views in the migrated schema use the utf8mb4_0900_ai_ci
collation. It looks like only internal mysql tables use this collation.
EDIT: looks like the problem was with aurora 3.05.2. After upgrading to Aurora 3.06.0 it started working.
Hi I understand that you receiving this error message "ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation 'regexp_like " this error usually occurs when MySQL tries to compare or operate with two data columns that different collation.
This is not caused by RDS but is a limitation of MySQL I recommend you to take a look at this third party document [1] on steps that can help resolve the issue. However, It is recommended to try any steps in the third party document in a staging environment before applying them on production" Please consider raising a ticket with AWS Support [2] so they can provide further assistance with this issue.
References links
[1] Third party Document - https://askubuntu.com/questions/1383077/1267-illegal-mix-of-collations-utf8mb4-0900-ai-ci-coercible-and-latin1-swe
[2] AWS support - https://aws.amazon.com/contact-us/
Relevant content
- asked 2 months ago
- asked 8 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 9 months ago