Logical backups, like Mysqldump, are not the fastest nor the most space-efficient way of backing up MySQL databases, but they have a huge advantage over physical backups. In this blog we will show you how to restore a single MySQL table using mysqldump

We are sometimes asked, how can you deploy ClusterControl and make it highly available from the application layer to the database layer? This blog will show you how to deploy a MySQL Replication as the CMON database storage engine with automatic failover and recovery in case of disaster.

In this two-part blog series, we are going to show you 9 tips and tricks on how to configure and prepare a MySQL server for production usage from a system administrator perspective.

A load balancer can help you to redirect traffic to available/healthy database nodes and failover when required. In this blog, we’ll see how to deploy and configure a database cluster with HAProxy on Google Cloud.

You typically want to have a full backup to ensure you can handle a total data loss scenario, but what would happen if only a single table had been dropped? Can we do a partial restore if we used Xtrabackup to create our safety data copy? Let’s explore this scenario in a short blog post.

This blog gives information for database designers, DBA’s and Developers who are new to Oracle NoSQL or MongoDB to help understand the terms and data model differences between these two NoSQL technologies.

Having your PostgreSQL nodes geo-located in different parts of the world is a fairly common practice, but many forget about the security. In this blog we will show you how to setup a standby node in a different location, using a VPN with ClusterControl.

Mongodump and mongorestore is the tool for logical backup used in MongoDB. They are included with MongoDB and they dump the data in BSON format. Mongodump is used to backup the database logically into dump files, while mongorestore is used for the restore operation. This blog shows you how to use them to restore a specific collection.

This blog post shows how to replace an intermediate MySQL or MariaDB master (a slave host relay to other slaves in a replication chain) with a binlog server running on MaxScale for better scalability and performance.

We wanted to take a moment to address how Severalnines is handling the Covid-19 pandemic. We have employees scattered across 16 countries over 5 continents, this means that some of our employees are at higher risk than others.

If you are looking for a Load Balancer solution for your MariaDB database, you should consider MaxScale. In this blog, we will show you how to install and configure MaxScale manually, and then look at how ClusterControl can help you in this task.

Client-Side Field Level Encryption (CSFLE) was introduced in MongoDB version 4.2 Enterprise offering DBAs the ability to adjust encrypt fields involving values that need to be secured. This is to say, the sensitive data is encrypted or decrypted by the client and only communicated to and from the server in an encrypted form.

PostgreSQL 12 comes with a great new feature called Generated Columns. In this blog, we’ll describe this new feature in detail, show how it works, and how to emulate this in a previous PostgreSQL version.

This blog post covers the implications of a MySQL InnoDB lock wait timeout error, how to deal with it, and how to track what was going one with the blocking transaction that caused the timeout to happen for the other transaction.

Database performance problems can happen anytime, one of the problems could be CPU related. Without fixing the cause, it will lead to more serious problems. This blog delivers some basic steps on how we can identify the problem from CPU utilization.