ProxySQL in Front of AWS RDS & Aurora MySQL — Part 1: Why and Where to Place It
Why put ProxySQL in front of RDS or Aurora MySQL? Placement trade-offs, alternatives comparison, and the lab topology that carries through this 5-part series.
ProxySQL in Front of AWS RDS & Aurora MySQL — Part 2: Wiring ProxySQL to Aurora MySQL
2 errors in 1,485 queries across a live Aurora failover — a 0.1s window vs. Part 1's 60s baseline. Here's the exact ProxySQL config that produced it.
ProxySQL in Front of AWS RDS & Aurora MySQL — Part 3: Query Routing, Read/Write Split, and Multiplexing
How ProxySQL's query rules route by pattern, user, schema, and digest — and why SET @user_var, not HikariCP's defaults, is what actually breaks multiplexing.
ProxySQL in Front of AWS RDS & Aurora MySQL — Part 4: HA, Failover Patterns, and TLS
Aurora topology flip: 15s. RDS Multi-AZ failover: 64s. Dual-node ProxySQL cluster sync timings, NLB detection gaps, backend TLS — all measured live on AWS.
ProxySQL in Front of AWS RDS & Aurora MySQL — Part 5: Monitoring, Tuning, and Troubleshooting
ProxySQL + Aurora stack in production: query digest baselines, lag threshold sizing, zero-error rolling upgrade, and monitor-user revocation failure pattern.
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.