About SRGArticlesRecruitment Information
About SRGArticlesRecruitment Information
HOME/Articles/[Additional Note] Regarding the issue where parameters other than binlog_format are also required for the Aurora Blue/Green deployment function

[Additional Note] Regarding the issue where parameters other than binlog_format are required for Aurora Blue/Green deployment function

This is Onkai Yuta (@fat47) from the Service Reliability Group (SRG) of the Media Headquarters.
#SRG(Service Reliability Group) mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, contributing to OSS, etc.

[Additional Notes] Introduction

Amazon Aurora Blue/Green deployments are a useful feature that allows you to safely test database changes (such as version upgrades or schema changes) without affecting your production environment, and then push them into production with minimal downtime.
ROW
However, as of April 2025, it has been confirmed that other parameter settings are also required.
💡
[Additional Note] As of May 2025, AWS has made a correction and the error no longer occurs even if you do not change the additional parameters.

Current issues (resolved in May 2025)

ON
  • enforce_gtid_consistency
  • gtid_mode
If these parameters are not set properly, you will see an error like the one below when creating a blue/green deployment.
Even if the UI is set to Japanese, the error messages will be displayed in English.
 
If you check the checkbox and select "Next", you will be prompted to enable the two parameters mentioned above for the Blue cluster.

Current situation

There is no guidance in the official user guide.

gtid_mode
References:Creating a blue/green deployment - Prerequisites for Aurora MySQL

Support has been contacted

A support case has been opened and is currently under investigation.
💡
[Additional Note] As of May 2025, AWS has made some changes and the error no longer occurs even if you do not change this parameter.

Solution

Enabling two additional parameters in the Blue cluster parameters

ON
Note, however, that these parameters are not dynamic and require a cluster reboot for changes to take effect.

Pattern for creating B/G from AWS CLI

Currently, if you create a B/G from the CLI, you can create the B/G without enabling these two parameters.
The following command will create the Green cluster with the same parameter group as Blue.
 
Please note that some people have pointed out that leaving these parameters enabled is safer in terms of replication.
As of Aurora MySQL v3.04, the default value for replica_parallel_workers is 4.

Conclusion

Please note that the current behavior of Aurora Blue/Green is not described in the documentation.
We will update this article as soon as we hear back from support regarding the status of the investigation.。
💡
[Additional Note] As of May 2025, AWS has made some changes and the error no longer occurs even if you do not change this parameter.
SRG is looking for people to work with us. If you are interested, please contact us here.