New to KubeDB? Please start here.

Postgres Compute Resource Autoscaling

This guide will give an overview on how KubeDB Autoscaler operator autoscales the database compute resources i.e. cpu and memory using postgresautoscaler crd.

Before You Begin

How Compute Autoscaling Works

The following diagram shows how KubeDB Autoscaler operator autoscales the resources of Postgres database components. Open the image in a new tab to see the enlarged version.

  Compute Auto Scaling process of Postgres
Fig: Compute Auto Scaling process of Postgres

The Auto Scaling process consists of the following steps:

  1. At first, a user creates a Postgres Custom Resource Object (CRO).

  2. KubeDB Provisioner operator watches the Postgres CRO.

  3. When the operator finds a Postgres CRO, it creates required number of PetSets and related necessary stuff like secrets, services, etc.

  4. Then, in order to set up autoscaling of the Postgres database the user creates a PostgresAutoscaler CRO with desired configuration.

  5. KubeDB Autoscaler operator watches the PostgresAutoscaler CRO.

  6. KubeDB Autoscaler operator generates recommendation using the modified version of kubernetes official recommender for different components of the database, as specified in the PostgresAutoscaler CRO.

  7. If the generated recommendation doesn’t match the current resources of the database, then KubeDB Autoscaler operator creates a PostgresOpsRequest CRO to scale the database to match the recommendation generated.

  8. KubeDB Ops-manager operator watches the PostgresOpsRequest CRO.

  9. Then the KubeDB Ops-manager operator will scale the database component vertically as specified on the PostgresOpsRequest CRO.

In the next docs, we are going to show a step by step guide on Autoscaling of various Postgres database components using PostgresAutoscaler CRD.