How to Overcome Accidental Data Deletion in MySQL & MariaDB
Someone accidently deleted part of the database. Someone forgot to include a WHERE clause in a DELETE query, or they dropped the wrong table. Things like that may and will happen, it is inevitable and...
Top Backup Tools for PostgreSQL
PostgreSQL has the reputation of being rock solid from its beginnings, and over the years has accumulated a set of impressive features. However the peace of mind that your on-disk data is ACID compliant —...
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...