Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Which Time-Series Database is Better: TimescaleDB vs InfluxDB

In the new time-series database world, TimescaleDB and InfluxDB are two popular options with fundamentally different architectures. One is based off a relational database, PostgreSQL, the other build as a NoSQL engine. In this blog, we’ll give you a short description of those two, and how they stack against each other.

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 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.

Backup Management Tips for TimescaleDB

Managing backup environments can be complex, and there are a number of options to consider - full, differential, incremental, point in time recovery, automatic restores for backup verification, uploading to remote systems or cloud, and so on. So how can we backup TimescaleDB? In this blog, we’ll see how ClusterControl can help us implement our backup management strategy for TimescaleDB.

How to Easily Deploy TimescaleDB

TimescaleDB is based on PostgreSQL, and therefore, supports streaming replication as the primary method of replication. However, PostgreSQL does not come with automatic failover. This can be a problem in a high availability production environment, as manual failover implies prolonged downtime.

The good news is that failover in TimescaleDB can be completely automated in ClusterControl 1.7.2. This blog shows us how to deploy such a setup.

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.

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

How to Migrate from MSSQL to MySQL

Migrating from proprietary engines into open source engines is a trend that is growing in the industry. In this blog we’ll see what is needed to move from Microsoft SQL Server to MySQL and why and how to do it.

How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime

Database migrations are a pain. They often require maintenance windows and can be a cause of downtime. In this blog, we will see how we can migrate a MySQL database from Amazon EC2 to an on-premise datacenter without any downtime whatsoever.

Pages