Does Amazon Oracle RDS Multi-AZ supports maximum protection mode?
My understanding of Amazon Oracle RDS Multi-AZ is, if there is connectivity loss between Primary and stand-by then RDS service kills the stand-by and keep primary alive. It is very similar to Max Availability mode of Data Guard solution. The problem with this solution is, the replication stops and it become a single AZ architecture and if the primary goes down then we have a data loss.
Does anyone know if we support a feature like Max Protection mode of Data Guard for Amazon RDS? It means that primary will hung if it is not able to commit on secondary. Most of the banks are looking for max protection kind of solution.
- 最新
- 最多得票
- 最多評論
Short answer: No.
Oracle DataGuard Maximum Protection mode relies on a Logwriter that write to the local and remote instance at the same time and keeps blocking until both DBs commited that the change is written. If there is no way to write at least two copies of the data the database just does not allow any changes anymore.
In RDS however there can be situation where data is not written at two locations at the same time anymore, even if that are mostly edge cases, like a switchover to the standby instance because primary one is lost. You will be able to write to the promoted standby even if the primary is not yet up and in sync again.
From my personal experience most of the DG setups in Maximum Protection I have seen did rely on 3 nodes, to be able to still write even if one node goes down. And such a setup is not possible with RDS. but you would be able to do that on EC2.
相關內容
- 已提問 10 個月前
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前