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
Kubernetes on virtual machines hands-on – part 2 Posted on May 28, 2022, updated on May 24, 2022 by Yannick JaquierTable of contents Preamble Stateless Nginx web server with a deployment Accessing a container from outside the Kubernetes cluster How to scale a pod with ReplicaSet Move pods from one node to another How to sanitize your deployment YAML files Useful commands References Continue reading