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...
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...
Choosing a MySQL Storage Engine and Its Impact on Backup Procedures
MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM being the most popular ones. Each storage engine implements a more specific set of features required for a type of workload, and...
The DevOps Guide to Database Backups for MySQL and MariaDB
This week we’re happy to announce that our new DevOps Guide to Database Backups for MySQL & MariaDB is now available for download (free)! This guide discusses in detail the two most popular backup...
Recovering your MongoDB Data
In previous posts of our MongoDB DBA series, we have covered Deployment, Configuration, Monitoring (part 1), Monitoring (part 2) and backup. Now it is time to recover MongoDB using a backup we made in the...
A Guide to MongoDB Backups
In previous posts of our MongoDB DBA series, we have covered Deployment, Configuration, Monitoring (part 1) and Monitoring (part 2). The next step is ensuring your data gets backed up safely. Backups in MongoDB aren’t...
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...
High Availability File Sync and Share – Deploying ownCloud with Galera Cluster for MySQL and GlusterFS
Cloud storage is hot. Dropbox, Apple iCloud, Google Drive, Microsoft SkyDrive and Amazon Cloud Drive all offer cloud sharing platforms where you can store documents in the cloud and access them from all your devices....
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...