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
SQL Server on Linux – installation – part 1 Posted on October 1, 2022, updated on April 26, 2023 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
PostgreSQL physical replication hands-on Posted on August 2, 2022, updated on August 2, 2022 by Yannick JaquierTable of contents Preamble Primary server setup Standby server setup for physical replication Without streaming replication With streaming replication Replication slots for physical replication Promoting a standby node Physical replication monitoring All in one pg_basebackup remote command References Continue reading
Kubernetes on virtual machines hands-on – part 4 Posted on July 4, 2022, updated on July 4, 2022 by Yannick JaquierTable of contents Preamble Persistent Volume creation Persistent Volume Claim creation PostgreSQL stateful deployment creation PostgreSQL stateful deployment testing Other Persistent Volumes plugins trials OpenEBS Container Storage Interface (CSI) open-local References Continue reading
Kubernetes on virtual machines hands-on – part 3 Posted on June 17, 2022, updated on July 15, 2022 by Yannick JaquierTable of contents Preamble PostgreSQL stateless deployment creation The stateless issue with database containers Creation of the cluster filesystem between Kubernetes nodes GFS2 OCFS2 References Continue reading