Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

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:

Using pg_dump and pg_dumpall to Backup PostgreSQL

pg_dump and pg_dumpall are popular tools used to backup PostgreSQL.  This blog shows you how to use them, with some tips and tricks for ensuring you have a proper backup strategy.

ClusterControl Release 1.6.1: MariaDB Backup & PostgreSQL in the Cloud

New Backup Management features for MariaDB, Deployment & Configuration Management features for PostgreSQL in the Cloud as well as a new Monitoring & Alerting feature with the integration with ServiceNow. This blog provides an overview of the new features in the ClusterControl 1.6.1 release.

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl

Point-in-Time recovery of MySQL & MariaDB involves restoring the database from backups prior to the target time, then uses incremental backups and the binlog to roll the database forward to the target time. This blog provides an overview of this new ClusterControl feature.

Top Backup Tools for PostgreSQL

This blog details various backup methods you can use for PostgreSQL including barman, bart and pgbackrest.

ClusterControl Tips & Tricks - Using socat on CentOS/RHEL for Streaming Backups

There are several ways to perform remote-to-remote data copy - socat, netcat, rsync, scp, sftp. ClusterControl previously used netcat for remote copy purposes, however we have flipped that decision to use socat. This blog post describes the reasons behind it.

Announcing ClusterControl 1.5.1 - Featuring Backup Encryption for MySQL, MongoDB & PostgreSQL

Announcing the 1.5.1 release of ClusterControl, which features encryption of backups for MySQL, MongoDB and PostgreSQL, a new topology viewer, support for MongoDB 3.4, several user experience improvements and more!

Pages