How to Verify Your MySQL Backups with ClusterControl
Backups are a basic point in all Disaster Recovery Plans, but only having a backup is not enough to guarantee correct data recovery. You must need to make sure that the backup is usable, and...
How to Backup Google Cloud SQL for PostgreSQL and Restore on Your Own Server
Google Cloud SQL for PostgreSQL is a fully managed database service to create and manage PostgreSQL relational databases using a Google Cloud Console. Google Cloud for PostgreSQL gives you more time to spend on developing...
Performance Testing Using MySQLdump and the MySQL Shell Utility
In my previous post I explained how to take a logical backup using the mysql shell utilities. In this post, we shall compare the speed of the backup and restoration process. MySQL Shell Speed Test ...
Tips for Storing Your TimescaleDB Backups in the Cloud
Daniel Keys Moran says “You can have data without information, but you cannot have information without data”. Data is the key asset in every organization, if you lose the data then you lose information. This,...
Logical Database Backups Using MySQL Shell
Mysqldump is a popular logical backup tool for MySQL which was originally written by Igor Romanenko. Mysqldump performs logical backups (set of SQL statements). By default, mysqldump does not dump information_schema tables and it never...
MongoDB Backup Management Tips for Sharded Clusters
Making proper backups of the database is a critical task. Besides setting the high availability architecture of your MongoDB for database services, you also need to have backups of your databases to ensure the availability...
The Grandfather-Father-Son (GFS) Backup Strategy
The GrandFather-Father-Son (GFS) is one of the most commonly used backup strategies used by businesses. GFS normally consists of three backup cycles such as daily, weekly, or monthly; though, other cycles like quarterly and yearly...
The Tower of Hanoi Backup Strategy
Of the common backup schemes, the Tower of Hanoi seems to be the most complex of them all. The scheme is named after a puzzle game where a player must move a tower of disks...
How to Backup Google Cloud SQL for MySQL and Restore on Your Own Server
Google Cloud SQL is a managed database service for MySQL, PostgreSQL, and SQL Server. Even if you are new to managed database services, it just takes a few minutes to set up Google Cloud SQL...
An Overview of Percona Backup for MongoDB
The known and popular backup method for MongoDB is mongodump. It is a logical backup method, similar to mysqldump in MySQL or pg_dump in PostgreSQL database. There is another backup tool called Percona Backup for...
How to Backup Your Amazon RDS for PostgreSQL Data and Restore on Your Own Server
Amazon Relational Database Service (Amazon RDS) is another service by Amazon, which allows you to deploy a scalable relational database in minutes in the cloud without the need to worry about infrastructure setup during the...
Migrating Azure Database for MySQL/MariaDB to an On-Prem Server
Database migrations can impose huge challenges when you consider how to start, what tools to use, and how to achieve a full database migration successfully. Earlier, we have listed the top open source you can...