Skip to main content
Scale PostgreSQL cluster for 1C
Last update:

Scale PostgreSQL cluster for 1C

Cloud database cluster PostgreSQL для 1С can scale. For example:

  • increase vCPU and RAM to improve cluster performance;
  • change the configuration line with local disk to another line with local disk — disk size must be larger than in the previous configuration, the number of vCPUs and RAM can be reduced or increased. It is possible to change a local disk lineup to a network disk lineup and vice versa only when cluster recovery.

Check out the list node configurations.

Configuration change process depends on the availability of replicas.

Principle of operation⁠

The process of changing the configuration depends on the availability of replicas:

  • if there are no replicas in the cluster — the master node will be stopped while the changes are applied, the cluster will be temporarily unavailable for reading and writing;
  • if there are replicas in the cluster — the cluster will be read and write accessible while the changes are being applied. The replicas will be stopped one by one and the configuration of each replica will be changed. The master node will then switch to one of the replicas and the configuration of the past master node will be changed.

The configuration change time depends on the amount of data in the cluster.

Scale the cluster⁠

carefully

If you have previously changed DBMS settings, they may be reset after scaling. Read more about settings PostgreSQL для 1С when scaling the cluster.

Scale the cluster when users are least active.

  1. To avoid stopping a master node in a cluster with no replicas, we first add a line. When scaling is complete, the replica can be deleted.

  2. В control panels go to Cloud platform → Databases.

  3. Open the cluster page → tab Settings.

  4. Click Scale the cluster.

  5. Pick another configuration. You can:

    • Select the configuration with the larger disk space only;
    • reduce or increase the number of vCPUs and RAM;
    • change a configuration line with a local disk to another line with a local disk. You can change a local disk ruler to a network disk ruler and vice versa only by cluster recovery.

  6. Optional: increase the number of lines in the cluster.

  7. Click Save.

  8. After scaling clear the DNS cache.

  9. Verify that the cluster has scaled correctly.

Clear DNS cache⁠

  1. Open the CLI.

  2. Clear the DNS cache:

    sudo systemctl restart systemd-resolved