Relationship between service resources
The main entity used in Managed Service for PostgreSQL is a database cluster.
Each cluster consists of one or more database hosts, which are virtual machines with DBMS servers deployed on them. Cluster hosts may reside in different availability zones. More about the geo scope of Yandex.Cloud.
A cluster with multiple hosts features automatic failover: one of the replica hosts becomes the master if the current master host is down.
A replica that explicitly specifies the source of the replication thread can't take the master role. For more information, see Replication.
A single-host cluster is cheaper, but it doesn't guarantee fault tolerance.
When creating a cluster, specify:
Host class: A VM template for deploying the cluster hosts. For a list of available host classes and their characteristics, see Host classes.
Environment: The environment where the cluster will be deployed:
PRODUCTION: For stable versions of your apps.
PRESTABLE: For testing, including the Managed Service for PostgreSQL service itself. The Prestable environment is first updated with new features, improvements, and bug fixes. However, not every update ensures backward compatibility.
A database cluster created in a folder can be accessed by all VMs connected to the same cloud network. Learn more about networking.
The service can automatically access the system and diagnostic information of your databases to plot monitoring graphs and maintain the health of your cluster. The service never queries or uses the data that you saved to the database.