Recovery & Repair

Database migrations can be a hefty job to handle. This blog looks at tools which are freely available either to be used or to be extended in order to achieve your desired data migration activities.

Barman is a popular PostgreSQL backup and restore tool. Its feature-rich functionality set makes it a perfect consideration for disaster recovery deployments. The blog explores that side of this useful PostgreSQL tool.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

A rollback is an operation which returns a database to a previous state. In this blog we will explore the features of MongoDB that help you prevent rollbacks.

This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection in the event of an outage or catastrophe.

While temporary tables are short-lived, temporal tables on the other hand are designed to give access to the data over time. In this blog, we will take a look at temporal tables in MariaDB and how to use them.

Page fault errors occur at the moment MongoDB wants to get data that is not available in active memory of the database hence forced to read from disk, creating latency. This blog explores this issue and how to fix it.

In a PostgreSQL multi-cloud environment, if your primary node fails on your main cloud provider, you must be able to promote the standby node in a secondary one to keep the system running. In this blog, you will see why you need failover, how to do it manually, and how ClusterControl does it.

A multi-cloud environment is useful for geo-distributed topologies or even as part of a disaster recovery plan, but there is a risk of split-brain in this kind of scenario. In this blog, we will see what a split-brain is and how ClusterControl can help you to avoid this important issue.

Using a battle-tested system to manage your backups is the best way to keep your data safe and usable in case of failure. In this blog, we’ll compare two backup management systems, PGHoard and ClusterControl, and we’ll see how to install and use these systems.

pg_dump and pg_restore are common tools used for taking and recovering logical backups for PostgreSQL. In this blog we will take a look at pg_restore, how it works, and how ClusterControl’s recovery features compare.

Point-in-Time Recovery (PITR) is a common part of a disaster recovery plan (DRP). In this blog we’ll take a look at how PITR is performed on Amazon RDS for PostgreSQL, MySQL & MariaDB. We will also look at how ClusterControl does it and see how it compares with RDS.

Covering for the DBA? In this blog, we’ll share some recommendations to follow in the case that you need to failover your database and don’t have an automatic failover process in place or it failed for some reason.

The COVD-19 pandemic has paralyzed businesses, leaving some to seek alternatives to improve their Disaster Recovery plans. Especially in the case where their DBAs or engineers are infected by sickness. This blog covers the importance of automation, documentation of the work, & disaster recovery planning with some database backup tips.

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

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.