Articles

Troubleshooting a ClusterControl MySQL PXC cluster, part 2

In a previous blog post I wrote about the steps to take to troubleshoot and restore in its working state a Percona database cluster.  This blog article adds some more information. Finding the most advanced nodeYou bootstrap…

Interpreting Munin graphs

Munin is a great resource monitoring tool that is simple to install and configure.  It shows data in form of graphs, which once you've learned to interpret often allow you to pinpoint an issue in one instant.Among other things, we use Munin…

Password change in ClusterControl

It is a good idea to periodically change passwords on your system, especially if you've the feeling that they have been shared too much around.Here we'll see the correct way to change the MySQL password for the cmon or root user in a database…

Troubleshooting a ClusterControl MySQL PXC cluster

We've been testing ClusterControl with three Percona XtraDB Cluster nodes on a virtualized environment and found it to be pretty resilient to faults.  Even after performing a brutal shutdown of all VMs (which is equivalent to pulling the plug…

Upgrading Percona XtraDB Cluster from 5.5 to 5.6

This blog post will explain how to update a Percona XtraDB Cluster 5.5 to the latest version, 5.6.  We'll assume a cluster of three nodes, managed via ClusterControl.We'll be doing the upgrade by allowing for some downtime, bringing down…

Updating ClusterControl

Severalnines ClusterControl is an application that allows you to deploy, manage, monitor, and scale several types of database clusters (MySQL, Percona XtraDB, MariaDB, MongoDB).Installation can't possibly be easier -- all you have to do…