Stop/Start RDS Blue replicate to Green

Question

I am thinking to use the Blue/Green deployment to setup a development DB for MariaDB.
When the Green DB instance is setup, I will like to stop the replication from the Blue so that changes in Green will not be over written.

When the changes to Green is tested, that is after code development is ready, the changes will be applied to Blue using SQL script.
After code deployment, replication from Blue will be turned on so that Green is in sync with the production.

But is there a way to stop/start replication from Blue to Green?

Accepted Answer

Hi,

Thank you for asking your question.

To stop replication from Blue to Green on RDS for MariaDB, you can use `CALL mysql.rds_stop_replication;`[1], then start using `CALL mysql.rds_start_replication;`[2] on Green database instance.

[Importing data to an Amazon RDS MariaDB or MySQL database with reduced downtime](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html) might help to setup replication.

During stop replication, Blue database instance needs to keep all binary log until resume replication to avoid data loss. You can set binlog retention hours using `call mysql.rds_set_configuration`[3] on Blue database instance. Increasing retention hours it will be increasing disk consumption as well following increasing write workload on Blue database instance. Please monitor `FreeStorageSpace` on Blue environment.

* [1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-stored-proc-replicating.html#mysql_rds_stop_replication
* [2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-stored-proc-replicating.html#mysql_rds_start_replication
* [3] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-stored-proc-configuring.html#mysql_rds_set_configuration-usage-notes.binlog-retention-hours

I hope this might help.

Stop/Start RDS Blue replicate to Green

관련 콘텐츠