ClusterControl

This blog describes how to use ClusterControl and ProxySQL to implement an SQL firewall in front of your database servers. The firewall uses a regular expression matching engine to inspect SQL statements going to the database through the proxy, and determines whether to allow, block, reroute or rewrite the incoming query.

ProxySQL typically sits between the applications and the database servers, so we have to be careful that it does not become a single point of failure (SPOF). In this blog post, we’ll explain how you can set up a ProxySQL cluster for redundancy.

This whitepaper will discuss what proxies are, what their use is and how to build a highly available and highly controllable MySQL and MariaDB database environment using modern proxies such as HAProxy, ProxySQL and MaxScale.

The new release of ClusterControl 1.7.0 introduces SCUMM (Severalnines ClusterControl Unified Management and Monitoring). Monitoring MySQL with SCUMM Part 1 adds the efficiency and productivity for a MySQL Database Administrator.

In a disaster recovery plan, the amount of data you can afford to lose, also called RPO, is directly dependent on Point in Time Recovery (PITR) features of your data infrastructure.

In this blog, we will see what PITR is, when it’s needed, how to easily use it with ClusterControl; and how, when setup correctly, it is an important element of a  disaster recovery plan.

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 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.

In this blog post, we’ll look into how to monitor your ProxySQL instances in-depth using ClusterControl’s new agent-based monitoring approach with Prometheus.

In this blog, we will show you how to monitor Galera Cluster for MySQL or MariaDB using Prometheus. We will have a look at the newly released SCUMM architecture for agent-based monitoring and how ClusterControl deploys Prometheus and exporters to collect database metrics and the graphs available in the different dashboards.

NDB Cluster is an advanced storage engine in MySQL, and provides automatic sharding and replication of data. However, it does take quite a bit of effort to administer. This blog post explains how to import MySQL NDB Cluster into ClusterControl so you can manage it from a web interface.

This blog post describes the process of easily deploying MySQL NDB Cluster using ClusterControl.

In this blog, we will see a new way to personalize your PostgreSQL monitoring with Prometheus. We will have a look at the newly released SCUMM architecture, how ClusterControl deploys Prometheus and exporters to collect database metrics and the graphs available in the different dashboards.

Announcing the availability of our first white paper on ClusterControl, the only management system you’ll ever need to automate and manage your open source database infrastructure! Download ClusterControl - The Guide today!

This blog provides an overview of the new agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in the ClusterControl 1.7 release.

In this webinar replay, we discuss how to effectively monitor distributed database clusters or replication setups for MySQL, MariaDB, PostgreSQL and MongoDB. We look at different types of monitoring infrastructures, from on-prem to cloud and from agent-based to agentless. Then we dive into the different monitoring features available in the free ClusterControl Community Edition - from time-series charts of metrics, dashboards and queries to performance advisors.

Advisors provide specific advice on how to address issues in areas such as performance, security, log management, configuration, storage space, etc. Learn how to write your first basic database advisor using the ClusterControl Developer Studio.

The idea behind ClusterControl operational reporting is to put all of the most relevant data into a single document which can be quickly analyzed in order to get a clear understanding of the status of the databases and its processes. This blog post shows how to leverage the ops report functionality to understand the state of your MySQL, MariaDB, MongoDB and PostgreSQL infrastructure.

In this blog post, we’ll show you how to use ClusterControl to monitor multiple MySQL instances running on one host.

This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.

This blog post shows how to leverage ClusterControl performance monitoring and advisors functionality to keep your MySQL, MongoDB and/or PostgreSQL databases and clusters healthy.

In this blog, we will review some important concepts of High Availability, possible database HA architectures and useful components when implementing PostgreSQL HA. Then we will see how to use ClusterControl to deploy an entire high availability stack for PostgreSQL.