Online Schema Change for MySQL & MariaDB – Comparing GitHub’s gh-ost vs pt-online-schema-change
Database schema change is one of the most common activities that a MySQL DBA has to tackle. No matter if you use MySQL Replication or Galera Cluster, direct DDL’s are troublesome and, sometimes, not...
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...
Deploying and Monitoring MySQL and MongoDB clusters in the cloud with NinesControl
NinesControl is a new service from Severalnines which helps you deploy MySQL, Galera, and MongoDB clusters in the cloud. In this blog post we will show you how you can easily deploy and monitor your...
Schema Upgrades in Galera Cluster for MySQL and MariaDB – How to Avoid RSU Locks
Working as MySQL DBA, you will often have to deal with schema changes. Changes to production databases are not popular among DBAs, but they are necessary when applications add new requirements on the databases. If...
Webinar Replay: 9 DevOps Tips for Going in Production With MySQL / MariaDB Galera Cluster
Many thanks to everyone who participated in this week’s webinar on ‘9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster’. The replay and slides are now available to watch and read...
MySQL Database Security Upgrade Instructions for Zero-day Exploit
You must have heard about the CVE-2016-6662, the recent zero-day exploit exposed in most of MySQL and its variants. The vulnerability flaw can be exploited by a remote attacker to inject malicious settings into your...
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...
How to Set up Read-Write Split in Galera Cluster Using ProxySQL
Edited on Sep 12, 2016 to correct the description of how ProxySQL handles session variables. Many thanks to Francisco Miguel for pointing this out. ProxySQL is becoming more and more popular as SQL-aware load balancer...
Webinar Replay: MySQL Query Tuning – Process & Tools
Many thanks to everyone who participated in this week’s first part of our webinar trilogy on MySQL Query Tuning. This time we looked at the process and tools to consider when tuning MySQL queries. It...
Infrastructure Automation – Deploying ClusterControl and MySQL-Based Systems on AWS using Ansible
We recently made a number of enhancements to the ClusterControl Ansible Role, so it now also supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster). The updated role uses the awesome ClusterControl...
Adding Existing Databases and Clusters (Updated)
In our previous blog post we covered the deployment of four types of clustering/replication: MySQL Galera, MySQL master-slave replication, PostgreSQL replication set and MongoDB replication set. This should enable you to create new clusters with...
What's New in ClusterControl 1.3.1 Documentation
If you haven’t upgraded to ClusterControl 1.3.1, you should! It’s full of great new features and enhancements. We have lots of documentation to help you get started. Documentation on older versions is also available in...