Does Amazon Oracle RDS Multi-AZ supports maximum protection mode?

0

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.

AWS
MODERATOR
asked 5 years ago414 views
1 Answer
1
Accepted Answer

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.

EXPERT
answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions