Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB

Networks may not be always stable or reliable, but your database clusters have to. This blog discusses the things to keep in mind when designing an HA solution for MySQL or MariaDB, deployed across potentially unreliable networks.

PostgreSQL High Availability with Master-Slave & Master-Master Architectures

Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing).

For HA PostgreSQL configurations we can have several architectures, but the basic ones would be master-slave and master-master architectures.

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.

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.

Comparing Database Proxy Failover Times - ProxySQL, MaxScale and HAProxy

This blog describes the failover and switchover operations executed by ClusterControl, and compares failover times when using ProxySQL, MaxScale and HAProxy.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Top PG Clustering HA Solutions for PostgreSQL

Achieving high availability and clustering in PostgreSQL is not an easy task. In this blog entry we discuss some options for implementing these and not collapsing in the process!

ClusterControl 1.5 - PostgreSQL Load Balancing & ProxySQL Enhancements

This post provides an overview of the new load balancing features found in ClusterControl 1.5 including enhanced ProxySQL support and Load Balancing support for PostgreSQL.

MySQL High Availability tools - Comparing MHA, MRM and ClusterControl

This blog post compares HA solutions: MHA, MRM and ClusterControl.

Posted in:

Pages