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
PostgreSQL logical replication hands-on Posted on September 1, 2022, updated on August 30, 2022 by Yannick JaquierTable of contents Preamble PostgreSQL configuration PostgreSQL logical replication configuration and testing PostgreSQL logical replication monitoring References Continue reading