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
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 on the Network tab.
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.
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.
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.
|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|
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.