Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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 Monitor PostgreSQL using Nagios

Regardless of database technology, it is necessary to have a monitoring setup, to detect problems so we can take action, or simply to know the current state of our systems. In this blog, we’ll take a look at one of the most widely used monitoring tool: Nagios.

PostgreSQL Streaming Replication - a Deep Dive

In this blog, we are going to review a little bit of the history of PostgreSQL built-in replication features, and deep dive into how streaming replication works.

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

Updated: Become a ClusterControl DBA: Managing your Database Configurations

Learn about how to manage, alter and template your database configurations in ClusterControl for MySQL, MongoDB & PostgreSQL.

Updated: Become a ClusterControl DBA - Deploying your Databases and Clusters

Many of our users speak highly of our product ClusterControl, especially how easy it is to install the software package. Installing new software is one thing, but using it properly is another. We all are impatient to test new software and would rather like to toy around in a new exciting application than to read documentation up front. That is a bit unfortunate as you may miss the most important features or find out the way of doing things yourself instead of reading how to do things the easy way.

Upgrading to the ClusterControl Enterprise Edition

This blog details how to upgrade from the ClusterControl Community Edition to the Enterprise Edition and the value it brings to your database infrastructure.

Free Open Source Database Deployment & Monitoring with ClusterControl Community Edition

This blog details the features and functions found in the Community Edition of ClusterControl, a free-to-use system for deployment and monitoring of open source databases.

Become a ClusterControl DBA: Adding Existing Databases and clusters (updated)

In our previous blog post we covered the deployment of four types of clustering/replication: MySQL Galera, MySQL master-slave replication, PostgreSQL replication set and MongoDB replication set. This should enable you to create new clusters with great ease, but what if you already have 20 replication setups deployed and wish to manage them with ClusterControl?

Become a PostgreSQL DBA - How to Setup Streaming Replication for High Availability

In this post, we will show you how to set up master-slave replication with Postgres.