Simplify Your Database Scaling with Cloud SQL’s Smaller Read Replicas

Google Cloud’s managed database services such as CloudSQL and AlloyDB support creating Read Replicas to serve read workloads and offload primary instances. Applications can take advantage of Read Replicas to distribute read workloads to a Read-only instance.

In Recent release, Cloud SQL for PostgreSQL now offers smaller read replicas that do not necessarily require the same or higher CPU and RAM capacity as their primary instances.

Cloud SQL release notes | Cloud SQL Documentation | Google Cloud

Let’s consider below CloudSQL for PostgreSQL with current configuration os 2vCPU, 7.5 GiB RAM.

CloudSQL Instance

CloudSQL Primary Instance

To Demonstrate the new releases feature, we will create a smaller Read replica instance with size 1vCPU,3.75 GiB RAM

Creating Smaller Read Replica — CloudSQL for PostgreSQL

Newly Created Read Replica instance with size smaller as compared to Primary instance.

Newly added Read Replica instance

Read Replica — Small instance as compared to Primary.

Conclusion.

Read Replicas now support smaller instance sizes, which can be helpful for optimizing database configurations when the primary instance requires a higher configuration level than is necessary for read workloads.