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 was using netcat for remote copy purposes, however we have flipped that decision to use socat. This blog post...
How to Schedule Database Backups with ClusterControl
Database backup is a critical part of database management and has to be carefully planned. Scheduling a backup is not enough; backup data also needs to be verified for consistency and integrity. There are other...
Featuring Backup Encryption for MySQL, MongoDB & PostgreSQL – ClusterControl 1.5.1
What better way to start a new year than with a new product release? Today we are excited to announce the 1.5.1 release of ClusterControl - the all-inclusive database management system that lets you easily...
Point-in-Time PostgreSQL Database Restoration
The ability to perform backup and restore of your data is one of the fundamental requirements of any DBMS. In a previous post, we discussed Postgres backups in general. In this blog post, we’ll look...
ClusterControl 1.5 – Automatic Backup Verification, Build Slave From Backup and Cloud Integration
At the core of ClusterControl is its automation, as is ensuring that your data is is securely backed up and ready for restoration whenever something goes wrong. Having an effective backup strategy and disaster recovery...
Announcing ClusterControl 1.5 – Featuring Automatic Backup Verification and Cloud Upload
Today we are excited to announce the 1.5 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases - and load balancers...
How to Fail or Crash Your MySQL Instances for Testing
You can take down a MySQL database in multiple ways. Some obvious ways are to shut down the host, pull out the power cable, or hard kill the mysqld process with SIGKILL to simulate an...
MySQL & MariaDB Database Backup Resources
Most organizations do not realize they have a problem with database backups until they need to restore the data and find it’s not there or not in the form that they were expecting. The designated...
Logical & Physical PostgreSQL Backups
Taking backups and having a recovery plan is one of the most important tasks of a DBA - they are crucial to the availability and integrity of the data. You can build replication clusters spanning...
Backup Best Practices for MySQL, MariaDB and Galera Cluster
Many thanks to everyone who registered and/or participated in Tuesday’s webinar on backup strategies and best practices for MySQL, MariaDB and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. If you missed...
Video: Interview with ProxySQL Creator René Cannaò
We sat down at Percona Live 2017 with ProxySQL creator René Cannaò to talk about the new release of ClusterControl, what’s is coming up for ProxySQL, how it is being received by the MySQL Community...
Full Restore of a MySQL or MariaDB Galera Cluster from Backup
Performing regular backups of your database cluster is imperative for high availability and disaster recovery. If for any reason you lost your entire cluster and had to do a full restore from backup, you would...