Resource relationships in Managed Service for PostgreSQL
The main entity Managed Service for PostgreSQL operates is a database cluster.
Each cluster consists of one or multiple database hosts, which are virtual machines with deployed DBMS servers. Cluster hosts may reside in different availability zones. You can learn more about Yandex Cloud geography in the Platform overview section.
A cluster of two or more hosts is natively highly available because one of its replica hosts will assume the master role upon the current master host's failure. To learn more about how the number of hosts affects cluster availability, see this section.
Note
A replica that has an explicitly specified replication thread source cannot take the master role. To learn more, see Replication.
The minimum number of hosts per cluster depends on the selected disk type. The default cluster configuration offered in the management console includes two hosts.
Warning
We do not recommend creating a cluster having a single host. While being cheaper, such a cluster is anything but highly available.
A cluster's computing capacity depends on its host class, which is the virtual machine template used to deploy the cluster's hosts. For a list of available host classes and their specs, see Host classes.
To manage connections and balance the cluster load, the service architecture features the Odyssey connection pooler. To learn more, see Connection management.
You can access a cluster created in a folder from any VM in the same cloud network. For more information on how the network works, see this Virtual Private Cloud guide.
Alert
The service can automatically access the system and diagnostic information of your databases to render monitoring charts and maintain your cluster health. It never accesses or uses the data you entered into the database manually.
Be mindful of what is managed by the service and what, by the Yandex Cloud customer. Understanding these zones of control makes you an efficient user of cloud resources and helps avoid potential database-related issues. For more information, see Zones of control between managed database (MDB) service users and Yandex Cloud.