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.

 

Amazon RDS Custom for Oracle – create database

After creating CEV (Custom Engine Version) here, we can create our RDS Custom Oracle database.
Before creating the database, the environment for RDS Custom database must be set.

Detailed description here

Amazon RDS Custom for Oracle – create CEV

AWS Custom RDS is a feature of AWS RDS designed to provide more flexibility for running database workloads that require specific configurations not supported by the standard managed RDS offerings. It is especially useful for applications that need custom database software, extensions, or configurations that go beyond the capabilities of the default RDS configurations. One of the main advantages is that it is giving you administrative access to both the database and the underlying operating system.

In order to use RDS Custom and to create a database, CEV(Custom Engine Version) is required. CEV is a feature of RDS Custom, designed to allow customers to create and manage custom database engine versions.

I will create now a CEV for RDS Custom for Oracle. Here is what has to be done.