Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1

A few days ago was the release of a new version of ClusterControl, the 1.7.1, with several new features, including for PostgreSQL. In this blog, we will see how to deploy PostgreSQL 11 version using ClusterControl. We’ll also check out the new backup verification feature that you can use to automatically test your backups.

PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends

PostgreSQL has seen real growth in the past few years, getting closer and closer to MySQL, which continues to be the world’s most popular open source database. In this blog we explore what’s been happening with PostgreSQL in 2018 and some predictions for the future.

How to Upgrade PostgreSQL10 to PostgreSQL11 with Zero Downtime

The old way to accomplish upgrades on PostgreSQL used to be using pg_upgrade, dumping and restoring, or using some third party tools, all of them with their own caveats. Nowadays, PostgreSQL allows us to use logical replication which, in contrast to physical replication, you can replicate between different major versions of PostgreSQL. In this blog, we're going to see how we can upgrade our PostgreSQL 10 to PostgreSQL 11 with zero downtime using logical replication.

Database Backups - Comparing MariaDB Mariabackup and Percona Xtrabackup

Percona XtraBackup is one of the most used tools for backing up MySQL and MariaDB databases. Mariabackup is a fork of XtraBackup, extending its functionality to support compression and at-rest encryption. In this blog, we will look at the differences between these two, and also see how we use them.

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.