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 RDSCustom – Performance Analysis of AWS db.m5 Instances: Sequential & Random Read/Write Benchmarks

This post presents the results of IOPS performance testing for Oracle running on Custom RDS in AWS. The tests were conducted using the fio benchmarking tool across three instance types: db.m5.large, db.m5.xlarge, and db.m5.4xlarge. The storage used was General Purpose SSD (gp2) volumes. The database remained active but was not under any load during the tests.
Here are Step-by-Step guide to creating a CEV and deploying an Oracle Database on RDS Custom.

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.