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...
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...
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...
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...
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...
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...
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 -...
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...
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...
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...
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...
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...