Oracle Data Guard per Pluggable Database hands-on Posted on February 10, 2025 , Modified on February 10, 2025 , by Yannick JaquierTable of contents Preamble Databases Data Guard preparation Container databases preparation Create a new pluggable database for replication Data Guard Broker configuration Data Guard Broker configuration creation Copy of source pluggable database datafiles Pluggable Data Guard testing Preparation Switchover Failover Pluggable Data Guard cleaning Errors encountered ORA-00922: missing or invalid option wth edit configuration prepare dgpdb command _DGMGRL legacy service name RMAN duplicate command error DGM-17437 References Read more Oracle Data Guard, High Availability Leave a comment
Citus as a distributed database plugin hands-on Posted on February 20, 2024 , Modified on September 22, 2026 , by Yannick JaquierTable of contents Preamble Citus distributed database installation Citus distributed database configuration Citus distributed database testing Citus distributed database cluster management Handle node failure Removing nodes Adding nodes References Read more PostgreSQL High Availability Leave a comment
Galera Arbitrator as an odd node in Galera cluster Posted on February 14, 2023 , Modified on November 9, 2023 , by Yannick JaquierTable of contents Preamble Galera Arbitrator installation Galera Cluster configuration Galera Arbitrator configuration Galera Cluster testing References Read more MariaDB Galera, High Availability 1 comment
SQL Server on Linux – Log Shipping – part 4 Posted on January 1, 2023 , Modified on March 24, 2023 , by Yannick JaquierTable of contents Preamble Samba installation and configuration On primary server On secondary server Log shipping configuration On primary server On secondary server Start the log shipping configuration Log shipping failover testing Log shipping monitoring References Read more SQL Server High Availability Leave a comment
SQL Server on Linux – Availability Groups – part 3 Posted on December 1, 2022 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Preamble Cluster nodes preparation Availability Group for High Availability (CLUSTER_TYPE = EXTERNAL) Availability Group creation for SQL Server Availability Group creation for Pacemaker Linux Availability Group for Read Scale (CLUSTER_TYPE = NONE) Availability Group creation for SQL Server Manual failover without data loss References Read more SQL Server High Availability 11 comments
SQL Server on Linux – Failover Cluster Instances – part 2 Posted on November 1, 2022 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Pacemaker, SQL Server and Linux installation Failover Cluster Instances Pacemaker configuration SQL Server failover testing Conclusion References Read more SQL Server High Availability 2 comments