Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
11 blog posts in 1 category

ClusterControl Tips & Tricks - Dealing with MySQL Long Running Queries

Long running queries are pretty much inevitable in MySQL or MariaDB, and unfortunately, they can lead to disastrous results. But why do queries take long time to execute? How do you deal with them?

This blog post shows how you can use ClusterControl to easily detect them, especially in environments with many database instances.

How to Monitor MongoDB with Prometheus & ClusterControl

ClusterControl’s new agent-based monitoring of MongoDB with Prometheus offers dashboards with graphs of high resolution metrics data. In this blog, we will have a look at the different graphs that are available to users.

ClusterControl Developer Studio: Creating an Advisor to check for SELinux and Meltdown/Spectre Part 2

Advisors are a great way to extend the ClusterControl functionality and implement your own security check mechanism. It provides basic Web UI reporting, can send email alarms, and manage scripts directly through the Developer Studio..

In this part 2 of blog series, we will show you how to integrate Meltdown/Spectre vulnerability checks, setup an alarm, and debug your JS script.

ClusterControl Developer Studio: Using ClusterControl Advisor to create checks for SELinux and Meltdown/Spectre Part 1

ClusterControl Advisors is a great feature that you can extend and implement as your own security check mechanism that provides basic Web UI alarms, send email alarms, and script management directly through our Developer Studio.

In this part 1 of a blog series, we’re showing you how to check SELinux and Meltdown/Spectre vulnerability to get alarms and be notified as to the state of your servers.

Using the Galera Replication Window Advisor to Avoid SST

In Galera Cluster, the gcache provides incremental state transfers by sending transactions to joining nodes. But if the gcache file is too small, this may cause full state snapshot transfers. The Galera replication window advisor will continuously review if your gcache size is large enough.

Video: ClusterControl Developer Studio Introduction

This video introduces you to the Developer Studio for ClusterControl which is included in all versions and let’s you build your own advisors to monitor, secure, and automate your environments.

ClusterControl Developer Studio: Custom database alerts by combining metrics

ClusterControl allows you to write elaborate advisors. This post shows you how to combine multiple metrics and trigger alerts if your MongoDB replication window becomes smaller than 24 hours.

ClusterControl Developer Studio: MongoDB Replication Lag Advisor

This post describes how to keep an eye on MongoDB replication lag via a database advisor. The advisor is written in the ClusterControl Developer Studio.

ClusterControl Developer Studio: automatically scale your clusters

This post describes how to automatically scale a MySQL Replication topology via advisors, written in the ClusterControl Developer Studio.

ClusterControl Developer Studio: creating advisors using the MySQL performance schema

Learn how to write an advisor to analyze the MySQL performance schema and discover unused indexes and tables referenced without indexes.