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...
MongoDB Features – Sharded Deployments, Cluster-Consistent Backups, Advisors in ClusterControl 1.3.2 Release
The Severalnines team is pleased to announce the release of ClusterControl 1.3.2. This release contains new features, such as deploying MongoDB sharded clusters and scheduling cluster-consistent backups, MongoDB Advisors, a new alarm viewer and new...
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...
mysqldump or Percona XtraBackup? Backup Strategies for MySQL Galera Cluster
Coming up with a backup strategy that does not affect database performance or lock your tables can be tricky. How do you backup your production database cluster without affecting your applications? Should you use mysqldump...
Using BitTorrent Sync to Transfer Database Backups Offsite
BitTorrent Sync is a simple replication application providing encrypted bidirectional file transfers that can run behind NAT and is specifically designed to handle large files. By leveraging the simplicity of Bittorrent Sync, we can transfer...