Mult-AZ RDS deployments consistency and availability

0
  1. In Mult-AZ RDS with 1 standby deployment, if synchronous replication is used, wouldn't the availability be affected incase the standby replica fails?
  2. In Mult-AZ RDS with 2 standbys deployment, is the replication sync or async or semi-sync? If the replication is not sync, does it still provide monotonic read consistency on read replicas?
2 Respostas
0

Replication with the multi-AZ standby is synchronous as described in the following documentation.

https://aws.amazon.com/rds/faqs/?nc1=h_ls

No, a Multi-AZ standby cannot serve read requests. Multi-AZ deployments are designed to provide enhanced database availability and durability, rather than read scaling benefits. As such, the feature uses synchronous replication between primary and standby. Our implementation makes sure the primary and the standby are constantly in sync, but precludes using the standby for read or write operations. If you are interested in a read scaling solution, please see the FAQs on Read Replicas.

profile picture
ESPECIALISTA
respondido há um ano
profile pictureAWS
ESPECIALISTA
avaliado há um ano
0

There's a good explanation here - https://aws.amazon.com/rds/features/multi-az/.

  1. Note there's direct communication between the primary's EBS volume and standby's EBS volume so data can stay in sync when an instance is down. The purpose of this multi-az setup is to maintain availability when either one of the two instances is down.

  2. With 2 standbys replication is async so there can be replica lag as with normal read replicas, but you can expect it to be less in general due to the in-memory caching layer with this setup.

ESPECIALISTA
respondido há um ano
profile pictureAWS
ESPECIALISTA
avaliado há um ano

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas