MongoDB Monitoring and Trending: Part One
After covering the deployment and configuration of MongoDB in our previous blogposts, we now move on to monitoring basics. Just like MySQL, MongoDB has a broad variety of metrics you can collect and use to...
Deep Dive SQL Workload Analysis using pt-query-digest
In our previous post, we showed you how to interpret reports generated by pt-query-digest. Today we’d like to cover some of its more advanced features, as it is a pretty extensive tool with lots of...
Analyzing Your SQL Workload Using pt-query-digest
In our previous post, we discussed the different ways to collect data about slow queries - MySQL offers slow log, general log and binary log. Using tcpdump, you can grab network traffic data - a...
An Overview of Database Monitoring and Trending
So, you’ve been working with MySQL for a while and now are being asked to manage it. Perhaps your primary job description is not about support and maintenance of the company’s databases (and data!), but...
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...
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...
How to Manage and Monitor Your Existing PostgreSQL Servers
We are excited to announce support for PostgreSQL, probably the world’s most advanced open source RDBMS. ClusterControl can now be used to monitor database metrics, queries and schedule backups. With this new addition, ClusterControl now...