A How-To Guide for Galera Cluster
Since it was originally published more than 63,000 people (to date) have leveraged the MySQL for Galera Cluster Tutorial to both learn about and get started using MySQL Galera Cluster. Galera Cluster for MySQL is...
Video: Database Troubleshooting Tips for DevOps using ProxySQL
Metrics can be hard to interpret if you don’t know what you are looking at. ClusterControl counters this with automated failure detection and recovery that make sure any failed nodes or clusters are quickly brought...
DevOps Database Glossary for the MySQL Novice
When you need to work with a database that you are not 100% familiar with, you can be overwhelmed by the hundreds of metrics available. Which ones are the most important? What should I monitor,...
Video: ClusterControl Command Line Client (CLI) Product Demonstration
The video below details the features and functions that are available in the new ClusterControl Command Line Client (CLI) Included in the video are… Overview of the Command Line Interface Installation of the CLI Authentication...
MySQL High Availability Tools – Comparing MHA, MRM and ClusterControl
We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we’ll see how ClusterControl stacks up against these solutions....
Top Mistakes to Avoid in MySQL Replication
Setting up replication in MySQL is easy, but managing it in production has never been an easy task. Even with the newer GTID auto-positioning, it still can go wrong if you don’t know what you...
Troubleshooting MySQL Replication: Part Two
In the previous post, we discussed how to verify that MySQL Replication is in good shape. We also looked at some of the typical problems. In this post, we will have a look at some...
Troubleshooting MySQL Replication: Part One
Replication is one of the most common ways to achieve high availability for MySQL and MariaDB. It has become much more robust with the addition of GTIDs, and is thoroughly tested by thousands and thousands...
How to Manage Configuration Templates for Your Databases With ClusterControl
ClusterControl makes it easy to deploy a database setup - just fill in some values (database vendor, database data directory, password and hostnames) in the deployment wizard and you’re good to go. The rest of...
Online Schema Change With gh-ost – Throttling and Changing Configuration at runtime
(this post was edited on 13/01/2017 after comments from Shlomi N.) In previous posts, we gave an overview of gh-ost and showed you how to test your schema changes before executing them. One important feature...
MongoDB Sharding Ins & Outs: Part One
So far in the “Become a MongoDB DBA” series, we covered Deployment, Configuration, Monitoring (part 1), Monitoring (part 2), backup, restore and read scaling. In our latest post we showed how to offload read requests...
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...