Cloud Databases

Managed Databases is a cloud service provided by Totalcloud. It offers a turnkey solution that enables fast and simple deployment of database clusters in the cloud. A cluster can consist of one or multiple servers configured for data replication to ensure high availability and have automatic failover to protect against failures.

Cloud databases also include automated backups that allow data to be restored to a specific point in time (Point-in-Time recovery). This ensures data safety and preservation in unforeseen circumstances.

On-premises cloud databases are hosted on your own hardware or rented servers. As a customer, you are responsible for managing all aspects of the infrastructure: choosing and purchasing hardware, installing operating systems and databases, testing, ensuring security, configuration, and updates.

Totalcloud Managed Databases are fully managed database management systems (DBMS) hosted in the cloud. Their main advantage is that Totalcloud, as a cloud service provider, takes on any administration tasks.

Totalcloud area of responsibility includes:

— Commissioning, fine-tuning, and optimizing server hardware.
— Managing the Infrastructure Layer (IaaS).
— Setting up OS and databases.
— Ensuring uninterrupted access and backup.
— Scaling resources.
— Monitoring database performance.

A cloud database cluster includes:

— Database servers: physical or virtual systems that store and manage data.

— Master: the central node of the cluster responsible for processing writes, updates, and reads.

— Replicas: copies of the master that provide its fault tolerance. Replicas are used solely for reading data.

If the master fails, one of the replicas automatically assumes its role, ensuring continuous data access (failover). Once the master is restored, it becomes a replica again.

— PostgreSQL 12, 13, 14, 15, 16

— TimescaleDB based on PostgreSQL

— MySQL semi-sync 8.0— MySQL sync 8.0

— Redis 6

— Kafka 3.5

Leave the complexities of database maintenance to us. Totalcloud's responsibilities include:

— Providing access to resources, creating virtual machines, and installing and configuring the operating system and DBMS.
Once the client has created the DBMS, databases, and users, Servercore is responsible for:
— Automatic creation and storage of backups.
— Horizontal and vertical scaling (upon user request).
— Ensuring fault tolerance and failover in user-created fault-tolerant clusters.
Users of the service are responsible for monitoring the correctness of database connections, data schemas and structures, as well as the queries executed.

Yes, there is such an option. You can alter certain settings of your Totalcloud cluster quickly in the control panel:

— Name.
— Number of replicas in the cluster (increase or reduce).
— Server configuration: number of vCPUs, amount of RAM, and number of SSDs (increase or reduce).
— DBMS parameters (e.g., MySQL, PostgreSQL, or Redis), which are initially set by default depending on the chosen server configuration.

Note that you cannot change the subnet to which the cluster is connected. However, you can always recreate the DBMS cluster in a new subnet using a backup.

Backups of Totalcloud cloud databases are performed according to the following schedule:

— Full weekly backups.
— Incremental (delta) daily backups.
— For WAL files (PostgreSQL) or binlog files (MySQL): every 10 minutes or when a certain volume of changes accumulates.
Backups are stored for seven days, after which they are deleted. However, backups of deleted clusters are available for seven days post-deletion.

Once deleted, a cluster can be restored from its backups.

To enhance the fault tolerance of your database cluster and ensure automatic failover to a standby database in case of failure, you need to add replicas to the cluster.

If the master node fails, one of the replicas automatically takes over its role, ensuring uninterrupted application functionality. The failed master node will automatically be recreated and join the cluster as a replica.

Yes. For example, you can use Redis to cache, which can significantly improve the speed of your apps.