# Choosing the right database for your RTO and RPO requirements
<a name="choosing-database"></a>

When you have defined the DR strategy for your organization based on the table in the previous section, choose the databases that are the right fit for your RPO and RTO requirements. By default, all AWS database services provide backup and restore functionality. Use the following table to understand more advanced DR features provided by AWS database services and map them to your DR requirements. 


****  

| AWS database service | Replication method to DR Region | Possible standby classification | RTO | RPO | 
| --- | --- | --- | --- | --- | 
| Amazon RDS for MySQL | [Cross-Region read replica](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html#Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.my) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. Automation can minimize delays. | Typically under 1 second. | 
| Amazon RDS for PostgreSQL | [Cross-Region read replica](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html#Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.pg) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. Automation can minimize delays. | Typically under 1 second. | 
| Amazon RDS for MariaDB | [Cross-Region read replica](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html#Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.mdb) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. Automation can minimize delays. | Typically under 1 second. | 
| Amazon RDS for Db2 | [Cross-Region replica](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/db2-replication.html) | Warm standby (doesn't allow read queries) | Usually minutes. | Typically under 1 second. | 
| Amazon Aurora MySQL-Compatible Edition | [Global database](https://aws.amazon.com/rds/aurora/global-database/) has secondary cluster(s) in a different Region | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Typically under 1 minute. | Typically under 1 second. | 
| Amazon Aurora PostgreSQL-Compatible Edition | [Global database](https://aws.amazon.com/rds/aurora/global-database/) has secondary cluster(s) in a different Region | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Typically under 1 minute. | Typically under 1 second. | 
| Amazon DocumentDB (with MongoDB compatibility) | [Global cluster](https://docs.aws.amazon.com/documentdb/latest/developerguide/global-clusters.html) has secondary cluster(s) in a different Region | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Typically under 1 minute. | In seconds. | 
| Amazon ElastiCache (Redis OSS) | [Global datastore](https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Redis-Global-Datastore.html) has a secondary cluster in a different Region | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. Automation can minimize delays. | In seconds. | 
| Amazon DynamoDB | [DynamoDB global tables](https://aws.amazon.com/dynamodb/global-tables/) | Active/active configuration accepts write operations in secondary Region  | Zero or near zero. | Sub-second. | 
| Amazon RDS for Oracle | [Read replica promotion across Regions](https://aws.amazon.com/blogs/database/managed-disaster-recovery-and-managed-reader-farm-with-amazon-rds-for-oracle-using-oracle-active-data-guard/) (Oracle Enterprise Edition and Active Data Guard) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. | Typically under 1 second. | 
| Amazon RDS for Oracle (alternative) | [Mounted read replica promotion across Regions](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-read-replicas.creating-in-mounted-mode.html) (Oracle Enterprise Edition) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. | Typically under 1 second. | 
| Amazon RDS for SQL Server | [Cross-Region read replica](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html#Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.sq) (Microsoft SQL Server Enterprise Edition 2016-2019) | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/prescriptive-guidance/latest/strategy-database-disaster-recovery/choosing-database.html) | Usually minutes. Automation can minimize delays. | Typically under 1 second. |