Product Description Managed Databases
Managed Databases is a service for deploying and managing high-performance and fault-tolerant clusters of supported databases in the cloud.
You can work with Managed Databases in the control panel, via the Managed Databases API or Terraform (except OpenSearch).
The product supports user types and roles, projects, and project limits and quotas.
Records of operations with Managed Databases are saved in audit logs.
Supported Managed Databases
How Managed Databases work
Managed Databases are deployed in a cluster. A cluster is one or more database servers (nodes). Cluster nodes run on the basis of Cloud Platform resources.
Managed Databases support cluster monitoring, backups, and scaling. You can increase cluster fault tolerance and configure replication between nodes.
Database settings are preset by default upon cluster creation and depend on cluster configuration and database version. You can change them if necessary.
Configuring networks for a managed database depends on the specifics of the infrastructure into which the managed database is integrated.
Monitoring
In Managed Databases, you can monitor the cluster state in the control panel:
- view cluster node usage and database load information as charts in the control panel;
- view the cluster status;
- receive disk space notifications.
Cluster node and database metrics can also be exported in Prometheus format.
Learn more about monitoring in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis, and Kafka.
Backups
In Managed Databases, cluster backups are created automatically using WAL-G. All databases except Redis support point-in-time recovery (Point-in-Time Recovery). The backup frequency depends on the selected database.
Backups are stored in Selectel S3 isolated from other users' backups. Backups cannot be downloaded. Automatic backups cannot be disabled.
Learn more about backups in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis.
Scaling
A managed database cluster can be scaled—for example, you can increase vCPUs and RAM to improve cluster performance. You can select a configuration from a different configuration line, but the disk type must match and the disk size must be larger.
Learn more about scaling in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis, Kafka, and OpenSearch.
Fault tolerance and replication
PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis
By default, a cluster consists of one primary node—the master node. When connecting to the master node, all operations are available: read (SELECT) and write (INSERT, UPDATE, DELETE, and others).
To ensure cluster fault tolerance, add replicas—exact copies of the master node. They are read-only (SELECT). If the master node becomes unavailable, replicas take over its role, and the cluster continues operating normally. They can also be used to reduce the load on the master node during heavy read operations.
Clusters with replicas are covered by an SLA — we guarantee 99.95% write availability and 99.99% read availability.
The node placement type in a cluster depends on the presence of replicas in the cluster, the type of pool where the cluster is located, and the number of segments in the pool.
Learn more about fault tolerance in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis.
OpenSearch
The fault tolerance of an OpenSearch Managed Database cluster is affected by:
- index replication;
- the number of nodes in node groups;
- the node placement type in node groups.
Learn more in the OpenSearch cluster fault tolerance instruction.
Managed Database settings
Database settings affect database cluster performance. When creating a database cluster, values for all settings are configured automatically. The values are selected to ensure high cluster performance and vary depending on the cluster configuration and database version.
If the automatic values do not suit your tasks, for all Managed Databases except Redis and OpenSearch, you can set your own values when creating a cluster or change settings in an existing cluster.
Learn more about Managed Database settings in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, and Kafka.
Networks
When creating a Managed Database cluster, you must consider the specifics of the infrastructure into which the managed database is integrated: whether access to cluster nodes from the Internet is required and whether network connectivity with other Selectel services is needed.
A cluster can be connected:
- to a private subnet—a subnet without access from the Internet;
- to a public subnet (except OpenSearch and ClickHouse®)—all public subnet addresses are accessible from the Internet.
Once a cluster is created, the subnet cannot be changed.
Learn more about setting up network connectivity between a Selectel dedicated server and a Managed Database cluster in the instructions for PostgreSQL, PostgreSQL for 1C, PostgreSQL TimescaleDB, PostgreSQL PGVector, MySQL sync, MySQL semi-sync, Redis, and Kafka.
Areas of responsibility
Selectel provides
- hardware selection for high DBMS performance;
- operating system installation;
- DBMS installation and default configuration optimized for the selected configuration;
- updates and maintenance of the operating system and utility software;
- cluster reliability and fault tolerance—when you create a fault-tolerant cluster, we provide automated failover in case of failure;
- configuration and maintenance of the service network for cluster replicas;
- backup—automatic creation and storage of backups;
- cluster monitoring system in the control panel;
- secure data storage and protection against theft and leaks;
- compliance with 152-FZ requirements;
- availability of resources to scale the cluster if you initiate scaling;
- technical support.
The user provides
- correct connection to the database;
- optimal database query writing;
- database schema and data structure;
- modifying settings according to their workload profile and application behavior;
- initiating cluster scaling.
If you need help managing databases, order managed services.
ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.