By using AWS re:Post, you agree to the Terms of Use

How do i make a read replica of a database with a custom parameter group in a different region?

0

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-1with 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?