33 blog posts in 13 categories
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.
Barman is a backup and disaster recovery solution for PostgreSQL databases that allow you to achieve high business continuity requirements.
This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.
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.
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.
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.
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.
This blog details various backup methods you can use for PostgreSQL including barman, bart and pgbackrest.
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 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!
