Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Optimize Performance of ClusterControl and Its Components

This blog post explains a number of ways to improve performance of ClusterControl and its components.

Monitoring HAProxy Metrics And How They Change With Time

There is a lot information on the traffic that is routed through HAProxy, as well as the state of the backends. This blog post discusses different HAProxy metrics, which ClusterControl collects and presents in the agent-based monitoring mode with Prometheus.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster

Can we increase Galera performance if we speed up applying data that is replicated between its nodes? In this blog post, we assess the impact of having multiple wsrep_slave_threads on the overall performance of Galera cluster.

Database Monitoring - Troubleshooting Prometheus with SCUMM Dashboards

Our SCUMM dashboards rely on Prometheus and exporters to provide high-resolution monitoring data. However, there are cases when dashboards may not load. This blog goes through some troubleshooting guidelines.

Database Security - Backup Encryption In-Transit & At-Rest

Backup Encryption in-transit and at-rest are important when complying with PHI, PII, PCI DSS, GDPR, and HIPAA. This blog discusses how you can use ClusterControl to safely secure your data during transmission over the network or when persistently stored on disk.

ClusterControl Tips & Tricks - Best Practices for Database Backups

This blog is about good practices for taking database backups using ClusterControl 1.7. ClusterControl’s centralized backup management for MySQL, MariaDB, PostgreSQL and MongoDB provides you with hot backups of large datasets, point in time recovery, at-rest and in-transit data encryption, data integrity via automatic restore verification, cloud backups (AWS, Google and Azure) for Disaster Recovery, retention policies to ensure compliance, and automated alerts and reporting.

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.

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:

Pages