switchover

MariaDB manual Switchover

I’m going to explain how to do a manual Switchover in a MariaDB HA setups using master-slave replication. In my example, let’s consider that I’ve a server01 and server02, both running on Ubuntu 20.04. server02 is currently the master, server01(…)

Configure Data Guard with odacli on ODA

Introduction I always thought integration of Data Guard was a missing feature on Oracle Database Appliance. For sure, you can configure Data Guard manually as you do on a classic server, but as an appliance, ODA should have proposed an(…)

A Serverless Standby Database called Oracle Autonomous Data Guard

By Franck Pachot . Announced by Larry Ellison last week, here it is: the Autonomous Data Guard. You can try it, unfortunately not on the Free Tier. First you create an Autonomous Database (ATP or ADW) and then(…)

Patroni Operations – switchover and failover

In this post we will have a look at switchover and failover of a Patroni cluster. As well as a look at the maintenance mode Patroni offers, which gives the opportunity to prevent from an automatic failover.

EDB Failover Manager 3.0 and PostgreSQL 10.1

By Mouhamadou Diaw Edb Failover Manager edb-efm30 is now released and supports PostgreSQL 10.1. Efm is an EDB tool which can be used to perform a switchover and a failover in a PostgreSQL standby environment. In this blog(…)

SQL Server AlwaysOn: is my database ready for failover?

In this blog post I just want to clarify values that we may find from the is_failover_ready column of the sys.dm_hadr_database_replica_cluster_states DMV. A couple of days ago, I had an interesting discussion with one of my customers during which he(…)