Oracle Data Guard per Pluggable Database hands-on Posted on February 10, 2025, updated 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 Continue reading
Citus as a distributed database plugin hands-on Posted on February 20, 2024, updated on February 21, 2024 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 Continue reading
Galera Arbitrator as an odd node in Galera cluster Posted on February 14, 2023, updated on November 9, 2023 by Yannick JaquierTable of contents Preamble Galera Arbitrator installation Galera Cluster configuration Galera Arbitrator configuration Galera Cluster testing References Continue reading
SQL Server on Linux – Log Shipping – part 4 Posted on January 1, 2023, updated 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 Continue reading
SQL Server on Linux – Availability Groups – part 3 Posted on December 1, 2022, updated on March 24, 2023 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 Continue reading
SQL Server on Linux – Failover Cluster Instances – part 2 Posted on November 1, 2022, updated on March 24, 2023 by Yannick JaquierTable of contents Preamble Pacemaker, SQL Server and Linux installation Failover Cluster Instances Pacemaker configuration SQL Server failover testing Conclusion References Continue reading