Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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!

Become a PostgreSQL DBA: Point-in-Time Database Restoration

In this blog post,  we describe how to perform point-in-time recovery in PostgreSQL

ClusterControl 1.5 - Automatic Backup Verification, Build Slave from Backup and Cloud Integration

Let's take a look on massive improvements that the new ClusterControl 1.5 brings in MySQL backup aspect.

Pages