Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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. 

A Guide to PGpool Part Three - Hints & Observations

Pgpool is a useful piece of software for connection pooling and load balancing. This is part three of the blog, which provides additional hints & observations by its author Vladimir Svedov to round up this topic.

Deploying Cloud Databases with ClusterControl 1.6

ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. This blog post shows you how.

An Overview of the Serial Pseudo-Datatype for PostgreSQL

Introduction to the special implementation of PostgreSQL serial data types typically used for creation of synthetic primary keys.

A Guide to Pgpool for PostgreSQL - Part Two

Pgpool is a useful piece of software for connection pooling and load balancing. This is part two of the blog which provides information on failover and recovery.

Comparing Cloud Database Options for PostgreSQL

Looking to deploy your PostgreSQL database stack to the cloud? Here is some information to help you choose which cloud option is the best.

Watch the Webinar Replay: How to Measure Database Availability

Watch Part 2 of our database high availability webinar special. In this session we focus on how to measure database availability. It is notoriously hard to measure and report on, although it is an important KPI in any SLA between you and your customers. We discuss the different factors that affect database availability and see how one can measure database availability in a realistic way.

Announcing ClusterControl 1.6 - automation and management of open source databases in the cloud

You can now deploy MySQL, MariaDB, MongoDB and PostgreSQL clusters in the cloud. ClusterControl now supports deployments of your databases on AWS, Azure and Google Cloud. This blog provides an overview of the new features in the ClusterControl 1.6 release.

An Expert’s Guide to Slony Replication for PostgreSQL

This blog provides an overview of Slony replication for PostgreSQL with tips and tricks for deploying and managing it in your setup.

The Best ETL Tools for Migrating to PostgreSQL

This blog reviews what ETL is and what tools are available to help you migrate your data to a PostgreSQL database.