DR solution decision matrix - AWS Prescriptive Guidance

DR solution decision matrix

Use the following table to review RPO, RTO, licensing and other features of disaster recovery options for Amazon RDS for Oracle and SQL Server and find the solutions that best fit your business requirements.

Feature

RPO (approximate)

RTO (approximate)

Licensing

Readable standby

Automatic failover

Endpoint change in failover

Setup and maintenance complexity

Multi-AZ deployment

(in-Region)

0

1–2 minutes

SE, SE2, and EE

No

Yes

No

Low

Amazon RDS PITR snapshot replication (cross-Region)

25 minutes

Hours

SE, SE2, and EE

No

No

Yes

Low

Automated snapshots using AWS Backup (cross-Region)

Hours

Hours

SE, SE2, and EE

No

No

Yes

Medium

Native transaction log backup replication (SQL Server only)

5–15 minutes

Minutes

SE and EE

Yes

No

Yes

High

AWS DMS

Secondsor minutes

Minutes

SE, SE2, and EE

Yes

No

Yes

High

Replica promotion (in-Region)

0–5 Minutes

Minutes

EE only

Yes

No

Yes

Low

Automated snapshots using AWS Backup (in-Region)

5 minutes

Hours

SE, SE2, and EE

No

No

Yes

Medium

Replica promotion (cross-Region)

0–15 Minutes

Minutes

EE Only

Yes

No

Yes

Medium