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

Question

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?

Answer

You can specify a custom parameter group for the read replica in the --db-parameter-group-name option of the AWS CLI command create-db-instance-read-replica. [1]

However, as you rightly observed, you can't specify a custom parameter group when you use the AWS Management Console for creating a read replica and it uses the default DB parameter group and DB option group for the specified DB engine.

[1] Cross-Region replication considerations: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.XRgn.Cnsdr

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

Contenido relevante