Using MariaDB Flashback on a MySQL Server
MariaDB has introduced a very cool feature called Flashback. Flashback is a feature that will allow instances, databases or tables to be rolled back to an old snapshot. Traditionally, to perform a point-in-time recovery (PITR),...
A Comparison of MongoDB Backup Strategies
Database backups are as important as the database itself, especially when ensuring business continuity after a technical hitch that may destroy the database completely. Typically, a backup is just a replication of the database’s contents...
How to Protect Your MySQL & MariaDB Database Against Cyberattacks When on a Public Network
It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often...
Database Backups 101: What to Report On
There are many tools offering database backup services, it could be on-premises, cloud or even both. Most tools provide some kind of monitoring and reporting services and the differences in the depth of information are...
MongoDB Backups: What is mongodump?
Database backup for any organization should be an important undertaking for ensuring business continuity in any case of database catastrophe. Restoration of the operational database is only possible if there is a backup in place....
Database Backups 101: When to Delete Your Backups
The volume of data is said to be increasing by the minute and estimated to reach 163 zettabytes (ZB) by 2025. This enormous data growth is contributed to by various devices generating data such as...
How Do I Know if My PostgreSQL Backup is Good?
Backups are a must in all Disaster Recovery Plan. It might not always be enough to guarantee an acceptable Recovery Point Objective, but is a good first approach. The problem is what happens if, in...
Managing Database Backup Retention Schedules
Attention: Skip reading this blog post if you can afford unlimited storage space. If you could afford unlimited storage space, you wouldn't have to worry about backup retention at all, since you could store your...
A Comparison Between the MySQL Clone Plugin and Xtrabackup
In one of our previous blogs we explained how Clone Plugin, one of new features that showed in MySQL 8.0.17, can be used to rebuild a replication slave. Currently the go-to tool for that, as...
Database Backups 101: Database Backup Security Considerations
Data security is important to protect the data in an organisation from unauthorised access, malicious attacks, or phishing activities. The term database security includes the methods taken to protect the security breach from the data...
Database Backups 101: Backup Retention Policy Considerations
A data retention policy is a guideline on how to retain, retrieve, or discard data in an organisation. A good, properly scheduled retention plan helps to achieve compliance, control costs, and it can allow you...
Database Backups 101: Logical vs Physical Backups
Databases are important to all businesses, therefore, it is fundamental to have a good backup policy in place and put it into implementation right from the start. Prior to deciding on the database backup method,...