Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Asynchronous Replication Between MySQL Galera Clusters - Failover and Failback

Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.

Failover for PostgreSQL Replication 101

Failover is a procedure that we hope we won’t have to use, but we must know how it works. In this blog, we will be cover the basic definitions of failover in PostgreSQL replication, and some example scenarios where failover can be useful.

6 Common Failure Scenarios for MySQL & MariaDB, and How to Fix Them

Database failures can happen at different levels, from schema corruption on an individual server to hardware or even an entire datacenter going down. So how do we troubleshoot and fix these? In this blogpost, we will walk through 6 different failure scenarios and see how we recovery from them.

Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts

Databases are a part of a wider mesh of infrastructure components, and as such, failover usually has some impact on more than just the database. Therefore, the failover software needs a mechanism to orchestrate changes across the infrastructure. This blog post describes how ClusterControl can be integrated with external infrastructure and tools, through the use of scripts executed during failover process.

How to Control Replication Failover for MySQL and MariaDB

Automated failover is a critical functionality in a MySQL or MariaDB replication setup, involving master-promotion and reslaving. Now, not all slaves are good master candidates, so how do you control which node gets picked? This blog introduces whitelists and blacklists.