- 最新
- 最多得票
- 最多評論
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.
相關內容
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前
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?