Recovery & Repair

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.

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.

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.

MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. No matter what you try, it is still possible that your slave will become inconsistent. What can be done to rebuild an inconsistent MySQL slave? In this blog post we’ll take a look at this problem.

Flashback is a feature available in MariaDB that allows instances, databases, or tables to be rolled back to an older snapshot. This blog post showcases how we can use MariaDB flashback on a MySQL server.

While there can be an array of reasons, sometimes a PostgreSQL slave can get out of sync with the master. In this blog we will show you how you can bring it back to the replication chain and ensure that the slave is again in-sync with the master.

This blog post explains ways to protect your MySQL or MariaDB database servers against cyberattacks when they are exposed to a public network.

In this blog post, we are looking into steps to take if you think you are having a MySQL outage in a Linux-based environment.

In this blog post, we look into ways to solve the full disk space issue for MySQL running in a Linux-based environment.

Keeping a standby node running all the time could be expensive and might not be necessary depending on the business availability requirements. In this blog, you’ll see how to create a cold standby PostgreSQL node with ClusterControl as a budget high availability alternative, how to create a backup policy and how to restore the backups in the cold standby node automatically using the AWS ClusterControl integrations.

This blog explains how to encrypt and backup a MySQL database using Percona Server for MySQL 8.0 including tips for performing both full and incremental backups.

Galera Cluster is a high available database that can handle failure of some of its nodes just fine. How should you decide on the size of the cluster and is it enough to have a quorum to tell the cluster is highly available? This blog post will answer those questions.

In this blog post, we look deeper into one of the most advanced features offered by ClusterControl called automatic database recovery and failover. ClusterControl is able to recover clusters, nodes and database-related processes to ensure you achieve the best database uptime possible.

This article gives an overview of the two most popular backup utilities available for MySQL, namely MySQL Enterprise Backup and Percona XtraBackup. We will discuss some best practices that can be applied to high availability topologies in order to make our backups reliable, secure and consistent.

In a PostgreSQL database, VACUUM is the process to reclaim space occupied by dead tuples. In this blog, we will look into this process to know how it works and which options are available.

In this blog, we'll show you how to install a PostgreSQL Cluster from scratch, convert the asynchronous replication (default) to a synchronous one. I’ll also show you how to rollback if the response time is not acceptable as you can easily go back to the previous state. You will also see how to deploy, configure, and monitor a PostgreSQL synchronous replication easily using ClusterControl using only one tool for the entire process.

If you are looking at replicating data from a PostgreSQL cluster to another, you can use the new ClusterControl 1.7.4 with its new Cluster-to-Cluster replication feature. In this blog, you will see how to configure such a setup and what it can do for you.

Ever wondered how to run multiple Galera clusters and keep them in sync? That’s exactly what you can do with the new Cluster-to-Cluster replication feature in ClusterControl 1.7.4.  In this blog, you will see how to configure replication between two Percona XtraDB or MariaDB Galera Clusters.

Replicating your database cluster to a remote datacenter is key in achieving Disaster Recovery with minimal RTO and RPO, but there are other reasons like datacenter migration or geo distribution. However, if managing a cluster was not hard enough, setting up and managing replicated clusters takes complexity to another level. In this blog, we will have a peek at a new ClusterControl 1.7.4 feature that allows you to set up replication between clusters.

A hot standby is a common term in computing, especially on highly distributed systems. It's a method for redundancy in which one system runs simultaneously with an identical primary system. In this blog how you can create a Hot Standby Node on Amazon AWS for Galera Cluster 4.0 using MariaDB.