Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

SQL Firewalling Made Easy with ClusterControl & ProxySQL

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.

Posted in:

How to Cluster Your ProxySQL Load Balancers

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.

Posted in:

Choosing a Database Proxy for MySQL & MariaDB - New Whitepaper

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.

Effective Monitoring of MySQL Replication with SCUMM Dashboards - Part 2

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.

How to Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery

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.

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.

How to Monitor Your ProxySQL with Prometheus and ClusterControl

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.

How to Monitor MySQL or MariaDB Galera Cluster with Prometheus Using SCUMM

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.

ClusterControl Tips & Tricks: Manage and Monitor Your Existing MySQL NDB Cluster

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.