I have a database in us-east-1 that is made using a parameter group that differs from the default default.mysql8.0
parameter group. When i try making a read replica of this database instance in the region eu-central-1
it fails because it uses the parametergroup default.mysql8.0
to create the replica instance instead of the custom parameter group. The status turns into Incompatible-restore
with the error message being:
The database instance was put into incompatible-restore. Found a fatal error during the restore: 2022-07-28T23:21:25.820075Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('0') and data dictionary ('1').. Please make sure lower_case_table_names parameter value in requested parameter group is consistent with source database
I've created the same custom parameter group in eu-central-1
with even the same name, but when the replica is being created AWS keeps using the default default.mysql8.0
parameter group nonetheless. This problem does not occur when i create the replica in the same region as the database is in.
So the question is: How do i make a read replica of a database with a custom parameter group in a different region?