Database Administration & Monitoring, Database management, MariaDB MariaDB manual Switchover 03.05.2023 by Joan Frey 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(…)
Database Administration & Monitoring Configure Data Guard with odacli on ODA 18.11.2020 by Jérôme Dubar 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(…)
Cloud, Database Administration & Monitoring, Oracle A Serverless Standby Database called Oracle Autonomous Data Guard 16.07.2020 by Oracle Team 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(…)
Database Administration & Monitoring, PostgreSQL Patroni Operations – switchover and failover 11.10.2019 by Open source Team 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.
Database Administration & Monitoring EDB Failover Manager 3.0 and PostgreSQL 10.1 07.03.2018 by Oracle Team 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(…)
Database Administration & Monitoring SQL Server AlwaysOn: is my database ready for failover? 14.06.2016 by Microsoft Team 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(…)