Troubleshooting a ClusterControl MySQL PXC cluster, part 2
DataIn 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…
Monitoring MySQL replication with Munin
DataMunin is a powerful system monitoring tool. What makes it so versatile is that you can write your own plugins to monitor any parameter you want.In this post I'll show how you can monitor the status of a MySQL replication. We'll be monitoring…
Interpreting Munin graphs
DataMunin 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
DataIt 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
DataWe'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
DataThis 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
DataSeveralnines 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…