Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
51 blog posts in 1 category

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

PostgreSQL Replication for Disaster Recovery

This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.

Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL

Watch the replay of this webinar for a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ll cover the dangers related to the failover process and look at how ClusterControl manages it as well as how it can be configured for both assisted and automated failover.

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

Simple Scheduling of Maintenance Windows across your Database Clusters

Maintenance is something that an operation team can not avoid. ClusterControl can be configured to simplify your maintenance routines. In this post, we’ll show you some advanced use cases of cluster-wide maintenance with iterations using ClusterControl CLI.

How to Deploy PostgreSQL for High Availability

In this blog, we will review some important concepts of High Availability, possible database HA architectures and useful components when implementing PostgreSQL HA. Then we will see how to use ClusterControl to deploy an entire high availability stack for PostgreSQL.

How to Automate Database Workload Analysis with ClusterControl Performance Advisors

ClusterControl provides you with a set of monitoring and performance advisors to add stability to your database infrastructures. It enables you to detect and solve unique problems in your environments. In this blog, you will see how you can also create custom advisors to extend your database environment monitoring with ClusterControl for free.

Multitenancy Options for PostgreSQL

How do you get multiple databases to co-exist in Postgres? Do you place them in separate databases within the same cluster? Or is a harder separation approach better? Are there any implications on security or the ability to get a consolidated view of the data? As we will see in this blog, there are different approaches to consider.

Introduction to Failover for MySQL Replication - the 101 Blog

With this blog post we aim to give you an introduction to failover handling in MySQL & MariaDB by discussing what failover is, why it is unavoidable and what the difference is between failover and switchover. We also discuss the failover process in its most generic form and touch a bit on different issues that you will have to deal with in relation to the failover process.

Watch the Webinar Replay: Disaster Recovery Planning for MySQL & MariaDB with ClusterControl

Watch the replay of this webinar with Vinay Joosery, CEO at Severalnines, during which he explains key disaster recovery concepts and walks us through the relevant options from the MySQL & MariaDB ecosystem in order to meet different tiers of disaster recovery requirements; and learn how ClusterControl can help user fully automate an appropriate disaster recovery plan.