Can we suggests single-AZ RDS for AlwaysoN configured databases

0

Hi All,

We are migrating the databases to RDS instance where on-premises configured with Alway on. we suggested to configure the Multi-AZ for production servers but Single-AZ is providing 99% SLA and application required the 99%. The Single-AZ and application SLA are same so , Can we configure the Single-AZ instead of multi-AZ.

SLA: https://aws.amazon.com/rds/sla/

Thanks

1回答
1
承認された回答

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

  1. Operational Excellence
  2. Reliability
profile picture
エキスパート
回答済み 2ヶ月前
AWS
サポートエンジニア
レビュー済み 2ヶ月前
  • 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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ