Oracle RDS Custom – Read Replica

Oracle RDS Read Replicas on AWS provide enhanced scalability and performance by allowing you to create up to five read-only copies of your primary Oracle DB instance. These replicas asynchronously replicate data from the source DB, making them ideal for read-heavy workloads, analytics, and disaster recovery scenarios. They help offload read traffic and can be promoted to standalone databases if needed.

Lets create Oracle RDS read replica and see what is behind the curtain. I will use Oracle RDS Custom – to be able to login to the underlying machine. Creating Oracle RDS custom is easy – first you must create (Custom Engine Version) – check here for details, then using this CEV, Oracle RDS Custom database can be created. You can find more information here.

 

Oracle RDS Multi-AZ Failover: High Availability in AWS

Amazon RDS Multi-AZ deployments enhance high availability and reliability for database instances by automatically replicating data to a standby instance in a different Availability Zone (AZ). In the event of a failure, AWS performs an automatic failover to the standby, minimizing downtime and ensuring business continuity. This setup is essential for mission-critical applications that require seamless database availability and disaster recovery.

Lets see how much does it take to perform Oracle RDS database failover? To find out, I created a small Oracle RDS database and tested failover with AWS CLI.