Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Customize your MySQL & MariaDB Backups with ClusterControl

ClusterControl provides centralized backup management for MySQL and MariaDB, and it supports the main backup tools - mysqldump, xtrabackup and mariabackup. The command line arguments used are supposed to be the most optimal for most use cases, but you might still want to customize these to fit your particular needs. In this post, we will show you how to do that.

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.

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.

A New Way to Personalize Your PostgreSQL Monitoring with Prometheus

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.

Custom Graphs to Monitor your MySQL, MariaDB, MongoDB and PostgreSQL Systems - ClusterControl Tips & Tricks

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

How to Deploy PostgreSQL for High Availability

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.

How to Monitor PostgreSQL using Nagios

Regardless of database technology, it is necessary to have a monitoring setup, to detect problems so we can take action, or simply to know the current state of our systems. In this blog, we’ll take a look at one of the most widely used monitoring tool: Nagios.

Performance Monitoring & Auditing PostgreSQL - Top Resources

This blog provides a collection of the top resources from Severalnines about monitoring & auditing your PostgreSQL database environments.

Failover for PostgreSQL Replication 101

Failover is a procedure that we hope we won’t have to use, but we must know how it works. In this blog, we will be cover the basic definitions of failover in PostgreSQL replication, and some example scenarios where failover can be useful.

How to Recover MySQL Galera Cluster from an Asynchronous Slave?

What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?