Categories
Products
Technologies
Top Rated docs

August 25, 2017

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

July 27, 2017

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

July 25, 2017

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

May 25, 2017

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

April 5, 2017

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

April 4, 2017

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

March 29, 2017

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

March 28, 2017

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

February 2, 2017

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

January 13, 2017

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

November 1, 2016

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

October 19, 2016

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

Subscribe below to be notified of fresh posts