Monitoring Galera Cluster – Understanding and Optimizing IO-Related InnoDB Metrics
This blog post is a follow up to our previous post on monitoring CPU-related InnoDB metrics in Galera Cluster. One of the main issues in terms of scalability of MySQL (and thereby also Galera) is...
Webinar Replay: How to Monitor MySQL Galera Cluster, MariaDB Cluster & Percona XtraDB Cluster
Thanks to everyone who attended and participated in this week’s webinar on 'How to Monitor Galera Cluster'. If you missed the sessions or would like to watch the webinar again & browse through the slides,...
Monitoring Galera Cluster – Understanding and Optimizing CPU-Related InnoDB Metrics
The performance of a Galera cluster is strongly connected to the performance of MySQL. Galera only supports the InnoDB storage engine, it is therefore important to have an insight into how InnoDB operates – what metrics...
Monitoring Host Metrics of Your Database Instances – How to Interpret Operating System Data
Monitoring the metrics of the database hosts is critical. By keeping Swap and Physical Memory usage within allowable limits, you’ll ensure that there is enough memory for queries to be executed and connections to be...
Chef Cookbooks for ClusterControl – Management and Monitoring for Your Database Clusters
If you are automating your infrastructure deployments with Chef, then read on. We are glad to announce the availability of a Chef cookbook for ClusterControl. This cookbook replaces previous cookbooks we released for ClusterControl and...
PagerDuty Incident Alerting for ClusterControl
Need to add phone and SMS alerting to ClusterControl? ClusterControl 1.2.8 introduces support for PagerDuty, an alerting service for Ops teams to schedule on-calls and add phone and SMS notifications to IT tools. By integrating PagerDuty with...
Archival and Analytics – Importing MySQL Data Into a Hadoop Cluster Using Sqoop
We won’t bore you with buzzwords like volume, velocity and variety. This post is for MySQL users who want to get their hands dirty with Hadoop, so roll up your sleeves and prepare for...
MongoDB Tutorial – On-Premises Cluster Management and Monitoring of MongoDB Replica Sets
Replica Sets in MongoDB are very useful. They provide multiple copies of data, automated failover and read scalability. A Replica Set can consist of up to 12 nodes, with only one primary node (or...
Nagios Plugin for ClusterControl
Nagios is a very popular open source IT infrastructure monitoring tool, used by sysadmins to watch out for problems in their systems. If you use Nagios and would like to utilize it to monitor your...
MongoDB Sharding – On-Premises Deployment and Monitoring of MongoDB Sharded Clusters
Last year, we did a survey asking our users about any other databases they were using alongside MySQL. A clear majority were interested in using other databases alongside MySQL, these included (in order of popularity)...