Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Benchmarking Managed PostgreSQL Cloud Solutions - Part Four: Microsoft Azure

The last in our four part series “Benchmarking Managed PostgreSQL Cloud Solution” this blog takes a close (and somewhat painful) look at Microsoft Azure and benchmark it for PostgreSQL using pgbench and sysbench.

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.

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 Managed PostgreSQL Cloud Solutions - Part Three: Google Cloud

This blog performance benchmarks Google Cloud SQL for PostgreSQL 9.6.10 using pgbench and sysbench.

Announcing ClusterControl 1.7.2: Improved PostgreSQL Backup & Support for TimescaleDB & MySQL 8.0

ClusterControl 1.7.2 includes support for TimescaleDB, MySQL 8.0 and Maxscale 2.2 as well as improved support for PostgreSQL monitoring & backups. It also launches two new features, CC Spotlight (a new search tool) and CMON HA (distributed fault-tolerant controllers).

How to Deploy Open Source Databases - New Whitepaper

Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. In this whitepaper we’ll show you how to install, configure and secure some of the most popular open source DB engines.

How to Deploy Highly Available PostgreSQL with Single Endpoint for WordPress

In this blog, we will learn how to setup Postgres in high availability mode, with a single endpoint for your WordPress service. We’ll also see how ClusterControl can help us manage the failover processes across database and load balancers.

Benchmarking Managed PostgreSQL Cloud Solutions - Part Two: Amazon RDS

This is part 2 in the series where we put different cloud providers head-to-head to see which one stands out. This blog is about benchmarking Amazon RDS using pgbench and sysbench and then comparing it to Amazon Aurora.

Pages