Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
748 blog posts in 13 categories

Effective Monitoring of MySQL With SCUMM Dashboards - Part 3

In this 3rd part of the blog series, we’ll discuss what ClusterControl’s new InnoDB Metrics and MySQL Performance dashboards have to offer. These dashboards provide a pretty in-depth view of MySQL performance. We’ll go through the different graphs, and see how a DBA can leverage them.

Simple Scheduling of Maintenance Windows across your Database Clusters

Maintenance is something that an operation team can not avoid. ClusterControl can be configured to simplify your maintenance routines. In this post, we’ll show you some advanced use cases of cluster-wide maintenance with iterations using ClusterControl CLI.

How to Create a Single Endpoint for your PostgreSQL Replication setup using HAProxy

PostgreSQL clients usually talk to a single endpoint, but what happens when you use a replication setup? Configuring the application to talk to the primary server does not work well if it fails! This blog reviews how HAProxy can be used on top of a replication setup, how to deploy and configure it, and how ClusterControl can help on these tasks.

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:

MySQL on Docker: Running ProxySQL as Kubernetes Service

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database servers. In this post, we’ll show you how to configure ProxySQL as a Kubernetes service.

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.

MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL to better take advantage of your distributed database service running on replication or Galera. In this post, we are going to cover how to run ProxySQL on Kubernetes as a helper container in a pod.

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.