Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Benchmark PostgreSQL Performance

This blog covers what you need to know to benchmark your PostgreSQL database to achieve peak performance.

PostgreSQL Schema Management Basics

This blog goes over the PostgreSQL Schema Management Basics that you should know when running a PostgreSQL environment.

PostgreSQL Privileges & User Management - What You Should Know

This blog demonstrates the basic PostgreSQL users and permissions.

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.

How to Secure Your Open Source Databases with ClusterControl

This blog post dives into ClusterControl's features which are built to assist administrators to have a secured database setup in production environment.

Announcing ClusterControl 1.5.1 - Featuring Backup Encryption for MySQL, MongoDB & PostgreSQL

Announcing the 1.5.1 release of ClusterControl, which features encryption of backups for MySQL, MongoDB and PostgreSQL, a new topology viewer, support for MongoDB 3.4, several user experience improvements and more!

Our Most Popular Database Blog Posts in 2017

These are the most popular Severalnines Open Source Database blogs from 2017.

Posted in:

PostgreSQL Load Balancing Using HAProxy & Keepalived

Promoting a new master server and failing over slaves sounds good, but your applications will need an easy way to keep track of the new master. That’s where HAProxy comes in. This blog post describes how to deploy HAProxy on top of your PostgreSQL replication setup.

Open Source Databases in 2017 and Trends for 2018

This blog features a video from our CTO and founder Johan Andersson on ClusterControl & databases in 2017 and our predictions for 2018.

Posted in:

Performing Replication Topology Changes for PostgreSQL

Database replication setups are rarely static. Servers can fail, the operating system or the database software might need to be upgraded. This means reshuffling server roles and moving replication links, while maintaining data consistency across all databases. This post explains how to perform these topology changes in PostgreSQL, while ensuring data consistency.