Launch both lab environments
Run a three-node Patroni cluster with etcd and HAProxy alongside three SQL Server nodes with replication and log shipping.
← All products
Practice failure before production
HA Cluster Lab
Start both database environments from one cross-platform launcher, generate concurrent application traffic, and practice high-availability operations without building a lab by hand.
- PostgreSQL Patroni HA
- SQL Server three-node lab
- Web-based CRUD load generator
What it helps you do
A practical path from signal to action
Generate concurrent CRUD load
Choose an engine, duration, worker count, and concurrent users, then watch operation logs and success rates in real time.
Exercise backup and failure scenarios
Schedule PostgreSQL WAL archives and SQL Server log backups while observing how traffic behaves through operational changes.
From the repository
Product facts
- Host requirement
- Docker 24+ and Docker Compose V2
- Web interface
- Flask app at http://localhost:5002
- PostgreSQL lab
- Three Patroni nodes, etcd, HAProxy, and backup storage
- SQL Server lab
- Three nodes with replication and log shipping
Verified scope
Support and project status
- Project status
- Lab
- Engine coverage
- SQL Server: Lab · PostgreSQL: Lab
- Last reviewed
- 2026-09-27
- Evidence
- Repository documentation ↗
Project evidence
Trust and maintenance links
How it works
Typical workflow
Start the lab
The launcher detects host RAM, lets you choose engines, creates memory overrides, and starts the containers.
Configure traffic
Select PostgreSQL or SQL Server and set duration, worker threads, and concurrent users.
Review and repeat
Inspect throughput, failure analysis, and downloadable reports, then repeat the scenario during failover or backup activity.
Run it yourself
Requirements and quick start
Requirements
- Docker 24 or newer
- Docker Compose V2
- Outbound access for images and the Microsoft package feed on first build
- No host Python or ODBC installation is required
Quick start
Windows PowerShell
irm https://raw.githubusercontent.com/rsharma155/sqlserver_postgres_ha_cluster/main/install.ps1 | iexmacOS or Linux
curl -fsSL https://raw.githubusercontent.com/rsharma155/sqlserver_postgres_ha_cluster/main/install.sh | bashSource: repository README.md ↗. Check the repository for the latest security notes, configuration options, and release status.
Explore another sqloptima product or go straight to the source.