Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
39 blog posts in 12 categories

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

Automate Deployment of your MySQL or Postgres Cluster from Backup

Restoring backups on newly deployed clusters can be time consuming. There are a number of procedures and checks to go through, and it is a task that lends itself to automation. This blog post shows you how to automate the entire process and deliver improvements in terms of speed, efficiency and cost.

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 Deploy MongoDB for High Availability

MongoDB provides ReplicaSets to help you address high availability database requirements. Although support for replication and failover is built-in, it is not enough for the database to be considered production-ready. That requires a set of policies and procedures, like getting alerted in case of performance slowdowns, anomalies or failures in a live environment. Backups are essential. Being able to automatically recover from different types of failures can drastically reduce downtime.

How to Deploy a Production-Ready MySQL or MariaDB Galera Cluster using ClusterControl

ClusterControl can be used to deploy open-source database clusters that are configured in complex topologies. The full high availability stack includes both database and proxy layers.

In this blog, we are going to show you how to deploy a production-grade Galera Cluster, complete with load balancers, for a high availability setup.

The Easy Way to Deploy MySQL Replication and ProxySQL with Automatic Failover

This blog post shows you how to easily deploy a highly available MySQL replication setup with ProxySQL and Keepalived using ClusterControl.

Using Kubernetes to Deploy PostgreSQL

This blog provides steps on how to run a PostgreSQL database on a Kubernetes cluster using Docker containerization.

Integrating Tools to Manage PostgreSQL in Production

As a follow up to the popular blog “Ten Tips for Going into Production with PostgreSQL”, this blog explores the different types of tools you would need to effectively run a PostgreSQL instance in a production environment.

Ten Tips for Going into Production with PostgreSQL

This blog provides tips & tricks for going into production with PostgreSQL.

Pages