Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
28 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.

Cloud Backup Options for PostgreSQL

This blog provides an overview of the options available for backing up your PostgreSQL database in the cloud including ClusterControl which provides easy cloud backup sync with a graphic interface.

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.

Using Barman to Backup PostgreSQL - An Overview

Barman is a backup and disaster recovery solution for PostgreSQL databases that allow you to achieve high business continuity requirements.

Pages