PostgreSQL Failover Testing: Real Scenarios (Part 4)
Test automatic and manual PostgreSQL failover. Kill the primary, watch Orchestrator promote, verify ProxySQL reroutes. Real outputs.
Orchestrator PostgreSQL Failover Configuration (Part 3)
Install Orchestrator 4.30.2 for PostgreSQL. Configure topology discovery, automatic and manual failover with pg_promote().
ProxySQL PostgreSQL Read/Write Splitting Setup (Part 2)
Configure ProxySQL 3.0.6 for PostgreSQL read/write splitting, health monitoring, and query routing. Tested on live VMs.
PostgreSQL HA Setup: Streaming Replication Guide (Part 1)
Build a 3-node PostgreSQL 17 streaming replication cluster on Multipass VMs. Step 1 of a ProxySQL + Orchestrator HA series.