RDS Blue/green deployment: Status Invalid Configuration

The error you're encountering suggests that there's a mismatch in how the blue/green deployment is being configured, specifically related to the database instance parameter group.

When upgrading from Aurora Serverless v1 to v2, it's important to note that this involves a major version upgrade, typically from MySQL 5.7 to MySQL 8.0. In this scenario, you need to create and specify a new parameter group that's compatible with the target version (MySQL 8.0) for your green environment.

Here are some steps to resolve this issue:

1. Create a new DB cluster parameter group compatible with Aurora MySQL 8.0. You can do this by selecting "aurora-mysql8.0" as the parameter group family when creating the new parameter group.

2. Configure the new parameter group with the necessary settings for Aurora Serverless v2, including setting the 'binlog_format' to 'ROW' if it's not already set.

3. When creating the blue/green deployment, make sure to specify this new parameter group for the green environment. This is crucial because you're upgrading to a new major version (MySQL 8.0), which requires a different parameter group.

4. Do not specify a DB instance parameter group name separately. For Aurora, you typically work with cluster parameter groups, not instance parameter groups.

5. Ensure that your current (blue) environment is properly configured with a parameter group that has binary logging enabled (binlog_format set to ROW). This is necessary for the blue/green deployment process.

By following these steps, you should be able to create the blue/green deployment without encountering the "Invalid Configuration" error. Remember, the key is to use the appropriate parameter group for the target version in your green environment, as this is a major version upgrade.

If you continue to face issues, it may be helpful to review your blue/green deployment configuration to ensure all other settings are correct for an upgrade from Serverless v1 to Serverless v2.
Sources
Preparing Aurora MySQL DB cluster for blue/green deployment - how to configure parameter group correctly? | AWS re:Post
Migrate Aurora Serverless v1 cluster to v2 | AWS re:Post
Unable to upgrade AuroraDB v2 for MySQL 5.7 to AuroraDB v3 using default cluster and instance parameter group | AWS re:Post