Reporting queries to run against a read replica, rather than your production DB instance. Keep in mind that the data on the read replica might be 'stale' because theīusiness reporting or data warehousing scenarios where you might want business In theseĬases, you can direct read traffic to your read replicas. In someĬases, your source DB instance might not be able to take I/O requests, forĮxample due to I/O suspension for backups or scheduled maintenance. Serving read traffic while the source DB instance is unavailable. You can direct this excess read traffic to one or Scaling beyond the compute or I/O capacity of a single DB instance for Replication with the standby replica is synchronous, and the standby replica can't You can configure a read replica for a DB instance that also has a standby replica configured for highĪvailability in a Multi-AZ deployment. Read replicas, see Creating a read replica in a different AWS Region. Amazon RDS establishes any AWS securityĬonfigurations needed to enable the secure channel, such as adding security group entries. Secure communications channel between the primary DB instance and the read replica. In some cases, a read replica resides in a different AWS Region from its primary DB instance. For more information, see Working with read replicas for Amazon RDS for Oracle.

The primary useįor mounted replicas is cross-Region disaster recovery. A mounted replicaĭoesn't accept user connections and so can't serve a read-only workload. The Oracle DB engine supports replica databases in mounted mode.

Amazon my reading list