1 Answer
- Newest
- Most votes
- Most comments
2
Multi AZ or Single AZ comes down to your risk appetite.
If you require Always on high availability then you should use MultiAZ. The SLA may be 99.9 but you should plan depending on your RPO RTO.
In the event of an AZ issue or issue with the primary database, do you require an alternative failover instance? There wouldn’t be any guarantee how long an outage may occur. Your primary RDS instance may be caught in a AZ fire or some natural event. It’s down to your risk and requirements and what ifs?
You may want to plan for the worse and hope for the best.
Multi AZ high availability is part of the AWS well architected framework both
- Operational Excellence
- Reliability
Relevant content
- Accepted Answerasked 10 months ago
- asked 5 years ago
- asked 2 years ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 25 days ago
Hi Gary, Agreed with you. Can you please help me where I can find the RDS single-AZ RPO and RTO.
I think RDS backup will saved in different region so we can restore databases/RDS if any case some thing happened to RDS region.
The RPO and RTO is something that you will need to define within your organisation regarding your own data and application. RDS Snapshot underlying storage is techincally S3 but thats performed daily. AWS Backup is designed to use the AWS global infrastructure to replicate your backups across multiple Availability Zones for durability of 99.999999999% (11 nines) in any given year, provided that you adhere to the current AWS Backup documentation.
How often will you be backing up the database as this would form part of your RPO
We have enabled the AWS automatic backups. RDS snapshot will be taken by every day and every 5 minutes log backup will happens for RDS SQL Server. Thanks for your feedback.
Ensure you test this scenario and that it works as expected.
apologies for late replay . Sure , Thanks