Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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:

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.

How ClusterControl Configures Virtual IP and What to Expect During Failover

This blog post covers how ClusterControl helps you to eliminate single point of failure of your database load balancers by using virtual IP address.

Video: ClusterControl & PostgreSQL - Product Demonstration

This video details the PostgreSQL features and functions available in ClusterControl.

MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Posted in:

Performing a Live Upgrade to MySQL 5.7

Once we’ve tested that our application works with MySQL 5.7, what is the best way to introduce 5.7 in our live environment? How can we minimize risks? What tools can help facilitate the process?

Posted in:

MySQL Replication failover: MaxScale vs MHA (part 4)

This post is an addendum on the MariaDB Replication Manager covering the new improved features

Posted in:

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

An overview of ProxySQL in a MySQL replication environment, and how ProxySQL adds features like failover and query control to the setup.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 3)

This post describes how you can implement automated failover with MariaDB using Maxscale and MHA and compares the two with each other.

Posted in: