Severalnines Blog
The automation and management blog for open source databases

ClusterControl Tips & Tricks - Custom graphs to monitor your MySQL, MariaDB, MongoDB and PostgreSQL systems

Severalnines

Graphs are important, as they’re your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, these are built on top of the metric sampling done by the controller. Those are designed to give you, at first glance, as much information as possible about the state of your database cluster. You might have your own set of metrics you’d like to monitor though. Therefore ClusterControl allows you to customize the graphs available in the cluster overview section and in the Nodes -> DB Performance tab. Multiple metrics can be overlaid on the same graph.

Overview tab

Let’s take a look at the cluster overview - it shows the most important information aggregated under different tabs.

You can see there graphs like “Cluster Load” and “Galera - Flow Ctrl” along with couple of others. If this is not enough for you, you can click on “Dash Settings” and then pick “Create Board” option. This is also a place in which, later, you can manage existing graphs - you can edit a graph by double-clicking on it, you can also delete it from the tab list.

When you decide to create a new graph, you’ll be presented with an option to pick metrics that you’d like to monitor. Let’s assume we are interested in monitoring temporary objects - tables, files and tables on disk. We just need to pick all three metrics we want to follow and add them to our new graph.

Next, pick some name for our new graph and pick a scale. Most of the time you want scale to be linear but in some rare cases, like when you mix metrics containing large and small values, you may want to use logarithmic scale instead.

Finally, you can pick if your template should be presented as a default graph. If you tick this option, this is the graph you will see by default when you enter the “Overview” tab.

Once we save the new graph, you can enjoy the result:

DB Performance tab

When you take a look at the node and then follow into DB Performance tab, you’ll be presented by, by default, eight different MySQL metrics. You can change them or add new ones. To do that, you need to use “Choose Graph” button:

You’ll be presented with a new window, that allows you to configure the layout and the metrics graphed.

Here you can pick the layout - two or three columns of graphs and number of graphs - up to 20. Then, you may want to modify which metrics you’d want to see plotted - use drop-down dialog boxes to pick whatever metric you’d like to add. Once you are ready, save the graphs and enjoy your new metrics.

Related Post

MongoDB Webinar - How to Secure MongoDB with ClusterControl

With authentication disabled by default in MongoDB, learning how to secure MongoDB becomes essential. In this webinar we will explain how you can improve your MongoDB security and demonstrate how this is automatically done by ClusterControl.

MongoDB Tutorial - Monitoring & Securing MongoDB with ClusterControl Advisors

Managing, monitoring, securing and optimizing MongoDB can be a lot of work. Wouldn’t it be great if this chore could be automated and give you advice at the same time? Enter the world of database advisors! The top 9 MongoDB advisors we selected for you will continuously check if your systems are in good health and give you tips on how to improve performance and security.

Posted in:

How MongoDB Database Automation Improves Security

The growing number of cyberattacks on open source database deployments highlights the industry’s poor administrative and operational practices. This blog explores how database automation is the key to keeping your MongoDB database secure.

Posted in:

Let the new ClusterControl secure your MongoDB deployments

Announcing the release of ClusterControl for MongoDB, which completes our vision to let you fully manage MongoDB whether on premise or in the cloud. With a full array of newly expanded features for MongoDB, ClusterControl provides developers and DBAs an alternative system with which to securely deploy and manage their open source database infrastructures.