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...
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...