Description

Managed Databases are fully managed database engines. Setting up, maintenance, and fault tolerance will be handled by Selectel. Cloud databases are powered by the Selectel Cloud Platform computing resources.

How Does It Work

Step 1

The user needs to fill out the form for creating a cluster:

  • select the computing resources configuration;
  • specify the basic replication settings (the number of servers in the database cluster);
  • select a subnet where the cluster will be available. If the subnet has not been created yet, you can create it in the Network section.

The service creates a database cluster.

You can rename, delete a cluster, or change its settings: increase or decrease the number of replicas and change the server configuration.

You cannot change the addresses of servers or the subnet that the cluster is connected to.

Step 2

After creating the cluster, you need to create users and databases.

Then you need to assign database access rights to users. This can be done both from the database card and from the user card.

You can create up to 50 databases and up to 50 users in a cluster. All names must be unique.

Step 3

The connection string in the Settings page helps to connect to the cluster and get started.

Database Engine Settings

Database engine settings are selected specifically to ensure high database performance. The settings parameters depend on the selected computing resources configuration for the database cluster. If the database cluster configuration is changed, the following parameters will be also changed automatically:

shared_buffers 
effective_cache_size 
maintenance_work_mem
max_worker_processes 
max_parallel_workers 
autovacuum_max_workers 
vacuum_cost_limit 
max_parallel_workers_per_gather 
max_maintenance_workers 

To view all database engine settings, connect to the database and run the show all command.

Billing and Payment

The costs for the database resources are provided on our website.

Glossary

Term Definition
Database server A Virtual Machine configured from the available Cloud Platform flavor lines
Database cluster One or more database servers (Virtual Machines) that replication is configured between
Flavor Server configuration in OpenStack terminology
Master The leading server of the database cluster that is used for reading, writing, and other data updates
Replica An additional database cluster server that is an exact copy of the master. The replica is read-only

Technical Characteristics

Two database engine versions are available in the service: PostgreSQL 11.6 and 12.1. The following flavor configurations are available for creating a database cluster:

  • 2 vCPU, 4 GB RAM, 32 GB local disk;
  • 2 vCPU, 8 GB RAM, 64 GB local disk;
  • 4 vCPU, 16 GB RAM, 128 GB local disk;
  • 8 vCPU, 32 GB RAM 256 GB local disk;
  • 16 vCPU, 64 GB RAM 512 GB local disk;
  • 32 vCPU, 128 GB RAM 1024 GB local disk.

Database clusters can only be created in private and public networks:

  • Private network — you can only connect to the database cluster from the selected private network;
  • Public network — you can connect to the database cluster from the Internet.