[Bug]: CloudSQL MySQL charset utf8 is an alias for utf8mb3, when setting the charset to UTF8, it keeps continously updating the database with UTF8

[arunthirupathi]

Is there an existing issue for this?

• I have searched the existing issues

Affected Resource(s)

Cloud SQL database

Resource MRs required to reproduce the bug

No response

Steps to Reproduce

Setting a cloud SQL MySQL 8 database to UTF8, will reproduce this bug. The database will end up permanently reconciling.

What happened?

I work in the Cloud SQL team at Google. We are seeing customers who uses crossplane to configure the MySQL database run into this issue. This will affect teh customers from doing regular operations like backup, as the continuous reconcilation competes with scheduled operations like backup/maintenace and impacting customers.

https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html MySQL 8.4 is changing UTF8 to utf8mb4.

Relevant Error Output Snippet

Continuous reconcilation.

Crossplane Version

0.0

Provider Version

0.0

Kubernetes Version

0.0

Kubernetes Distribution

GKE

Additional Info

https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html MySQL 8.4 is changing UTF8 to utf8mb4.