Tag: backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and third-party tools. For each, notes on the recovery point objective (or RPO, which is a measure of how up-to-date your application…

We get it. Preparing for the worst can be a bit of a drag. That’s likely why, according to some surveys, up to 40% of organizations don’t even bother to test their IT systems’ backup and disaster recovery (BDR) capabilities….

How do you know your Oracle Backups can be used to restore a database? Here is how to find out.

Most backup implementations to not take log management into consideration. Example: Have you seen thousands of backup logs or backup log dating back to 2017? Is it necessary? Worse, paged in the middle of the night for disk filling up….

SQL Server started having encrypted backups since SQL Server 2014. You can see the technical details here. This is a very good feature that allows you to encrypt the backups upon creation with different algorithms that will meet your security…

Cassandra nodetool provides several types of commands to manage your Cassandra cluster. See my previous posts for an orientation to Cassandra nodetool and using nodetool to get Cassandra information. My colleague has provided an in-depth analysis of backup strategies in…

Introduction In many database builds, backups pose a very large problem. Most backup systems require an exclusive table lock and don’t have any support for incremental backups; they require a full backup every time. When database sizes grow to several…

Cassandra is a distributed, decentralized, fault-tolerant system. Data is replicated throughout multiple nodes (centers) across various data centers. The fact that Cassandra is decentralized means that it can survive single or even multi-node failures without losing any data. With Cassandra,…

Overview Cloud storage is becoming more and more popular for offsite storage and DR solutions for many businesses. This post will help with those people that want to perform this process for MySQL backups directly into Amazon S3 Storage. These…