Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
32 blog posts in 13 categories

How to Use pgBackRest to Backup PostgreSQL and TimescaleDB

Managing backup environments can be complex, and, in case of failure, it’s important to reduce downtime and loss of data as much as possible. Full, differential and incremental backups are good options, they also help reduce the disk space usage. There are other important features like backup verification, uploading to remote systems or cloud, and compression, to complete our backup strategy. In this blog, we’ll see how we can use pgBackRest for backing up PostgreSQL and TimescaleDB and how we can manage all of these features from the same system.

Backup Management Tips for TimescaleDB

Managing backup environments can be complex, and there are a number of options to consider - full, differential, incremental, point in time recovery, automatic restores for backup verification, uploading to remote systems or cloud, and so on. So how can we backup TimescaleDB? In this blog, we’ll see how ClusterControl can help us implement our backup management strategy for TimescaleDB.

The Current State of Open Source Backup Management for PostgreSQL

This blog takes a deep-dive into the most popular open source backup programs available for PostgreSQL, what their current state is, and how they compare to one another.

Automate Deployment of your MySQL or Postgres Cluster from Backup

Restoring backups on newly deployed clusters can be time consuming. There are a number of procedures and checks to go through, and it is a task that lends itself to automation. This blog post shows you how to automate the entire process and deliver improvements in terms of speed, efficiency and cost.

How to Backup and Restore ClusterControl

Migrating ClusterControl to new hardware used to be a pain - you had to reinstall it on the new server, restore configuration/metadata from the old one and redo database grants so the new server can access your managed databases. Not any more! Starting with 1.7.1, it is possible to backup the ClusterControl server in one command and restore it on a new server, with data, grants and all.  This blog shows you how to do this using the s9s CLI.

Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1

A few days ago was the release of a new version of ClusterControl, the 1.7.1, with several new features, including for PostgreSQL. In this blog, we will see how to deploy PostgreSQL 11 version using ClusterControl. We’ll also check out the new backup verification feature that you can use to automatically test your backups.

Database Backups - Comparing MariaDB Mariabackup and Percona Xtrabackup

Percona XtraBackup is one of the most used tools for backing up MySQL and MariaDB databases. Mariabackup is a fork of XtraBackup, extending its functionality to support compression and at-rest encryption. In this blog, we will look at the differences between these two, and also see how we use them.

Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl

Watch the replay of this webinar on Backup Management for MySQL, MariaDB, PostgreSQL and MongoDB with ClusterControl. Whether you are looking at rebuilding your existing backup infrastructure, or updating it, then this webinar is for you.

How to Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery

In a disaster recovery plan, the amount of data you can afford to lose, also called RPO, is directly dependent on Point in Time Recovery (PITR) features of your data infrastructure.

In this blog, we will see what PITR is, when it’s needed, how to easily use it with ClusterControl; and how, when setup correctly, it is an important element of a  disaster recovery plan.

ClusterControl Release 1.6.2: New Backup Management and Security Features for MySQL & PostgreSQL

This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.

Posted in: