Top Rated docs

May 20, 2020

pg_restore Alternatives – PostgreSQL Backup and Automatic Recovery with ClusterControl

While there are various ways to recover your PostgreSQL database, one of the most convenient approaches to restore your data from a logical backup. Logical backups play a significant role for Disaster and Recovery Planning...

April 16, 2020

GDPR and Database Backups

‘Right to be Forgotten’, Article 17 in the EU General Data Protection Regulation (GDPR) talks about how a data subject has the right to request to remove it from any system. The owner of the...

April 8, 2020

My DBA is Sick – Disaster Planning & Backup Tips for SysAdmins

The alarming nature of COVID-19 is being felt globally. Many companies have closed or filed bankruptcy because of the global pandemic.  Most organizations did not see this coming. Large companies have a better chance of...

April 2, 2020

PostgreSQL Backups: What is pg_dumpall?

PostgreSQL is an open-source database management system that can be used to store or interact with the data of any application or website. If you are using a PostgreSQL database to store the information of...

March 31, 2020

MariaDB Backups: What is mariabackup?

It is essential that you choose the right technology for backing up your database as you don’t want to take any risk with your important production data. Also, you want to select a backup tool...

March 30, 2020

How to Restore a Single MySQL Table Using mysqldump?

Mysqldump is the most popular logical backup tool for MySQL. It is included in the MySQL distribution, so it’s ready for use on all of the MySQL instances.  Logical backups are not, however, the fastest...

March 24, 2020

How to Restore a Single Table Using Percona Xtrabackup?

Backups are the means of protecting from data loss - should something happen, you can easily restore it from the backup. You cannot predict what part of the data will have to be restored -...

March 20, 2020

Database Backups 101: What is Point in Time Recovery?

Point-in-Time Recovery (PITR) allows a database administrator to restore or recover a set of data from a backup from a particular time in the past, using a tool or a system. Once PITR starts logging...

March 19, 2020

How to Restore a Specific Collection in MongoDB Using Logical Backup

Keeping backups of your database is one of the most important tasks in any production environment. It is the process of copying your data to some other place to keep it safe. This can be...

March 18, 2020

How to Replace an Intermediate MySQL or MariaDB Master with a Binlog Server using MaxScale

Binary logs (binlogs) contain records of all changes to the databases. They are necessary for replication and can also be used to restore data after a backup. A binlog server is basically a binary log...

March 5, 2020

Setting Up a Geo-Distributed Database Cluster Using MySQL Replication

A single point of failure (SPOF)  is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity...

March 5, 2020

Database Backups 101: Tips on How to Verify Your Backups

Everyone knows backups are an important part of recovery to minimize downtime but, having multiple backups with errors will not be of any use for any immediate recovery. Backup verification is a process to test...

Subscribe below to be notified of fresh posts