Stop/Start RDS Blue replicate to Green
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?
- Newest
- Most votes
- Most comments
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 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.
Relevant content
- asked a month ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated 2 years ago
Your solution above works. I applied CALL mysql.rds_stop_replication; to Blue at first it didn't work. After applying mysql.rds_stop_replication; in Green, I made a column type change in Blue that change didn't flow through to Green. I then ran CALL mysql.rds_start_replication; on Green the column change in Blue was applied to Green thereafter. But I won't use Green as a development DBI as the retention consumes disk space. I would rather use DB restore to refresh the dev DB.
just wonder [3] where is the log retention stored? Is it on S3?