Data in transit encryption with MariaDB 10.6 (WolfSSL) Posted on January 24, 2023, updated on February 1, 2023 by Yannick JaquierTable of contents Preamble Data in transit encryption certificates generation Root Certificate Authority Server v3 certificate generation Client v3 certificate generation Data in transit encryption MariaDB configuration and testing One-way TLS for client Two-way TLS for client References Continue reading
SQL Server on Linux – Log Shipping – part 4 Posted on January 1, 2023, updated on December 9, 2022 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 November 1, 2022 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 December 1, 2022 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
SQL Server on Linux – installation – part 1 Posted on October 1, 2022, updated on September 29, 2022 by Yannick JaquierTable of contents Preamble SQL Server on Linux installation SQL Server on Linux command-line tools installation Final cleaning to have all database files in good directories AdventureWorks example database installation Conclusion and next steps 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