Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Self-Provisioning of User Accounts in PostgreSQL via Unprivileged Anonymous Access

This blog provides an overview of a layered database architecture paradigm for managing visibility with schema permission management in PostgreSQL.

PostgreSQL Triggers and Stored Function Basics

By building DML code into PostgreSQL, we can avoid duplicate implementation of data-related code in multiple separate applications that interface with the database. This ensures consistent execution of DML for data validation, data cleansing, or other functionality such as data auditing (i.e., logging changes) or maintaining a summary table independently of any calling application. In this blog, we’ll look at the basics of triggers and stored functions in PostgreSQL.

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.

More of My Favorite PostgreSQL Queries - and Why They Also Matter

This is the follow up to the popular blog ‘My favourite PostgreSQL queries and why they matter’. This new blog focusses on a particular query, multi-row UPDATE with a single CASE expression, and makes comparisons between that particular query, and one involving multiple single UPDATE statements.

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: