Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL

HAProxy is a great piece of software, but it may just not be enough for more demanding users and environments. How do you migrate from HAProxy to ProxySQL? This blog post explains the process and shows how ClusterControl can help.

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Deploying a single PostgreSQL instance on Docker is fairly easy, but deploying a replication cluster requires a bit more work. In this blog, we’ll see how to deploy PostgreSQL on Docker and how we can make it easier to configure a primary-standby replication setup with ClusterControl.

How to Automate Database Failover with ClusterControl

It might not be possible to avoid disasters, but with some preparation, it is certainly feasible to reduce the impact on your business. Automatic failover is one of those things. The goal of database failover automation is to minimize your downtime and reduce loss of money. However, failover can not always be automated as there are risks; false positives may lead to unnecessary escalations.

In this blog, we’ll have a look components you may use to build an automated stack, and take a closer look at ClusterControl’s failover functionality.

Introducing ClusterControl Spotlight Search

The new ClusterControl Spotlight Search can speed up your daily workflow and give you the ability to execute actions, go to pages and search for features in seconds... without leaving the keyboard. In this blog we’ll show you how it works!

How to Use pgBackRest to Backup PostgreSQL and TimescaleDB

Managing backup environments can be complex, and, in case of failure, it’s important to reduce downtime and loss of data as much as possible. Full, differential and incremental backups are good options, they also help reduce the disk space usage. There are other important features like backup verification, uploading to remote systems or cloud, and compression, to complete our backup strategy. In this blog, we’ll see how we can use pgBackRest for backing up PostgreSQL and TimescaleDB and how we can manage all of these features from the same system.

An Overview of Streaming Replication for TimescaleDB

TimescaleDB uses a stream of write-ahead log (WAL) records to keep the standby databases synchronized. In this blog, we’ll review some concepts related to Streaming Replication and how ClusterControl can help us configure it in an easy way.

Benchmarking Manual Database Deployments vs Automated Deployments

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

Scaling Your Time-Series Database - How to Simply Scale TimescaleDB

How do you scale TimescaleDB? How do you convert a single TimescaleDB instance to cluster with no downtime? How does the application know which database node to access? This blog post provides an overview of how to use ClusterControl to scale your time-series data with minimal effort.

How to Achieve Automatic Failover for TimescaleDB

Failover is the process of moving to a healthy standby component, during a failure or maintenance event. The quicker it can be done, the faster you can be back online. If you’re looking at minimizing downtime and meet your SLAs through an automated approach for TimescaleDB, then this blog is for you.

Performance Monitoring for TimescaleDB

Doing a performance monitoring in TimescaleDB is always a challenging task, especially for a very huge time-series data. ClusterControl offers a way to help a DBA or a developer to make things feasible and productive with the aid of the different features integrated within ClusterControl. Check out this blog as we showcases what are these and how you can leverage ClusterControl to monitor your TimescaleDB cluster.

Pages