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...
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...
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...
What’s New in ClusterControl 1.4 – Backup Management
ClusterControl 1.4 introduces some major improvements in the area of backup management, with a revamped interface and simplified options to create backups. In this blog post, we’ll have a look at the new backup features...
Database Cluster Management: Manual vs Automation
In a previous blog, we looked at the efficiency gains when automating the deployment of a Galera cluster for MySQL. In this post, we are going to dive into cluster management. Should we manage our...
A Guide to Max Open Files for MySQL
Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a...
How to Avoid SST When Adding a New Node to MySQL Galera Cluster
State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is...
Webinar Replay: Deciding on a Relevant Backup Solution
Thanks to everyone who joined us last week for this live session on backup strategies for MySQL and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the...
MySQL Backup and Restore Best Practices
It is not uncommon for developers, network/system administrators, or DevOps folks with general backgrounds to find themselves in a DBA role at some point in their careers. So, what does a DBA do? In the...
Simple Backup Management of Galera Cluster Using s9s_backup
Percona XtraBackup is a great backup tool with lots of nice features to make online and consistent backups, although the variety of options can be a bit overwhelming. s9s_backup tries to make it simpler for...