Preparing Aurora MySQL DB cluster for blue/green deployment - how to configure parameter group correctly?

Question

I was previously on serverless v1, changed it to provisioned instance. Goal is to move to serverless v2 on MySQL 8.0.39.

Next I need to prepare blue/green deployment, as per this I need to create a ROW binary group: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html#aurora-serverless-v2.upgrade-from-serverless-v1-procedure

It says to create a parameter group. I have default currently.

Questions while creating the group:
- On the parameter group family, do I select MySQL 5.7 (current) or MySQL 8.0 (the one green deployment would use)?
- On the Type, do I choose DB Parameter Group or DB Cluster Parameter Group?
- Do I attach the parameter group afterwards to the instance, before creating the blue/green? Does that override the default? I assume the parameters of the newly created group are the same as the default one.

Ty in advance.

re:Post Agent · Accepted Answer

To prepare your Aurora MySQL DB cluster for a blue/green deployment and transition from Serverless v1 to Serverless v2 on MySQL 8.0.39, you'll need to create a custom parameter group with binary logging enabled. Here's how to configure it correctly:

1. Parameter group family: Select the MySQL 5.7 family, as this corresponds to your current version. The green environment will use a different parameter group for MySQL 8.0 during the blue/green deployment.

2. Type: Choose "DB Cluster Parameter Group". Aurora uses DB cluster parameter groups to configure settings for all DB instances within a cluster.

3. After creating the parameter group, you need to modify it to enable binary logging. Set the 'binlog_format' parameter to 'ROW'.

4. Once you've created and configured the custom parameter group, you should attach it to your DB cluster before creating the blue/green deployment. This will override the default parameter group.

5. When you attach the new parameter group to your cluster, the parameters will initially be the same as the default group, except for the 'binlog_format' parameter that you modified.

6. After attaching the custom parameter group, you'll need to reboot your DB cluster for the changes to take effect.

Remember, enabling binary logging is crucial for the blue/green deployment process, as it allows data replication from the blue (current) environment to the green (new) environment.

When you create the blue/green deployment, you'll have the opportunity to specify a different DB cluster parameter group for the green environment, which should be compatible with MySQL 8.0 and Serverless v2.

It's important to note that this process may require some downtime when you reboot the cluster after attaching the new parameter group. Plan accordingly to minimize disruption to your applications.  
**Sources**  
[Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility) | AWS Database Blog](https://aws.amazon.com/blogs/database/upgrade-to-amazon-aurora-mysql-version-3-with-mysql-8-0-compatibility/)  
[DB cluster parameter groups for Amazon Aurora DB clusters - Amazon Aurora](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithDBClusterParamGroups.html)  
[Creating a blue/green deployment in Amazon Aurora - Amazon Aurora](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/blue-green-deployments-creating.html)

Preparing Aurora MySQL DB cluster for blue/green deployment - how to configure parameter group correctly?

Add your answer

Relevant content