Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome

Split brain syndrome is a state where a cluster of nodes is partitioned into smaller clusters of equal numbers of nodes, and each cluster believes it is the active cluster. This is a harmful state, as data is changed on a partition, without being replicated to the other. This blog post describes how to prevent a split brain from happening, and what can be done if it does happen.

Posted in:

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.

Posted in:

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.

Webinar Replay: How to Design Open Source Databases for High Availability

Watch this webinar replay on how to design open source databases for high availability. From discussing high availability concepts through to failover or switch over mechanisms, we cover all the need-to-know information when it comes to building highly available database infrastructures.

Posted in:

An Overview of Logical Replication in PostgreSQL

This blog provides an overview of the new logical replication function available in PostgreSQL 9.

Updated: ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or ProxySQL.

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.

Become a PostgreSQL DBA: Adding Additional Nodes To a Replication Setup

Master-slave replication setups can be very useful, as they provide multiple copies of the data for high availability or for scale out purposes. Master slave replication setups can be ver useful as they provide multiple copies of the data from a redundancy perspective., We will show you how to add nodes to an existing PostgreSQL replication setup using ClusterControl.

What’s New With MySQL Replication in MySQL 8.0

This blog will introduce you to the changes that are occurring in MySQL replication in the newest edition of MySQL 8.0.

Posted in:

What's New with ProxySQL in ClusterControl v1.4.2

We showcased some of the significant changes around ProxySQL on ClusterControl 1.4.2.

Posted in:

Pages