Ensure that your database cluster has the binlog_format set to ROW. To do this, go to the RDS console in AWS and click on your database cluster to open the details page. In the Configuration tab, DB Cluster Parameter Group and click on the name to view the Parameter Group. Search for binlog_format and verify that it has value ROW.
If the value isn’t ROW, edit the DB Cluster Parameter Group (or create a new one, if it’s the default group) and set the binlog_format to ROW. To make the settings take effect, you will need to reboot the databases. The fastest way to do so is to go back to the database cluster details page, select the Writer instance, click the Actions dropdown, and click Failover. This will sync the settings to both instances in the cluster. This should only take about a minute.
Make sure there is a DB Cluster Parameter Group of the target MySQL version that also has the binlog_format set to ROW. If it doesn’t exist, create one.
Back on the database cluster details page, click the Actions dropdown, and click Create Blue/Green Deployment.
Under Blue/Green Deployment Settings, fill in a meaningful but unique ID, such as “bridge-uat-2022-01-20”. Select the MySQL version you want to upgrade to and select the DB Cluster Parameter Group with the binlog_format=ROW. (The DB Instance Parameter Group doesn’t matter.) Click Create Staging Environment. This next step will take around 45 minutes.
In the database clusters list in RDS, click on your blue/green deployment. Click the Actions dropdown, and click Switch Over. Verify the details and click This switches your green deployment for your blue one, effectively upgrading your database. This takes up to 4 minutes. Note that your database will be unavailable during this time.
TODO
...