Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

ClusterControl Release 1.6.2: New Backup Management and Security Features for MySQL & PostgreSQL

This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.

Posted in:

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.

How to perform Schema Changes in MySQL & MariaDB in a Safe Way

This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through different scenarios and recomment some approaches for each.

How to Recover MySQL Galera Cluster from an Asynchronous Slave?

What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?

New Whitepaper: Disaster Recovery Planning for MySQL & MariaDB

Wondering about disaster recovery (DR) planning for MySQL and MariaDB? Unsure about RTO and RPO? Should you have a secondary datacenter? How about DR in the cloud? Well, this is the resource for you. In this white paper, we’ll explore DR concepts and discuss the different options available from the MySQL & MariaDB ecosystem for meeting different levels of DR requirements.

ChatOps - Managing MySQL, MongoDB & PostgreSQL from Slack

CCBot helps you monitor and manage your database Infrastructure from Slack. ChatOps is about bringing your DevOps work to your chats and conversations within a team, e.g. Slack. You can deploy database clusters, get status information, trigger backups, add nodes to your cluster or replication setup by talking to a chatbot, which understands ClusterControl commands.

ClusterControl Release 1.6.1: MariaDB Backup & PostgreSQL in the Cloud

New Backup Management features for MariaDB, Deployment & Configuration Management features for PostgreSQL in the Cloud as well as a new Monitoring & Alerting feature with the integration with ServiceNow. This blog provides an overview of the new features in the ClusterControl 1.6.1 release.

PostgreSQL Management and Automation with ClusterControl - New Whitepaper

This whitepaper provides an overview of what it takes to configure and manage a PostgreSQL production environment and shows how ClusterControl provides PostgreSQL automation in a centralized and user-friendly way.

Posted in: