Cloud Disaster Recovery for MariaDB and MySQL
MySQL has a long tradition in geographic replication. Distributing clusters to remote data centers reduces the effects of geographic latency by pushing data closer to the user. It also provides a capability for disaster recovery....
Safeguarding your Data with ClusterControl
In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in...
How to do Point-in-Time Recovery of MySQL & MariaDB Data Using ClusterControl
Backups are crucial when it comes to safety of data. They are the ultimate disaster recovery solution - you have no database nodes reachable and your datacenter could literally have gone up in smoke, but...
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...
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...
Video: Backup Tips for MySQL – Interview with Krzysztof Książek on the Upcoming Webinar
We sat down with Severalnines Senior Support Engineer Krzysztof Książek to discuss the upcoming webinar MySQL Tutorial - Backup Tips for MySQL, MariaDB & Galera Cluster. ClusterControl for MySQL Backup ClusterControl provides you...
How to Perform Efficient Backup for MySQL and MariaDB
All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal. Backups...