How I Set Up HAProxy + ProxySQL on a Single OVH VPS for My Solo SaaS

Short summary

Solo SaaS founder running DockSky on €14/month OVH VPS shares how HAProxy + ProxySQL in front of MySQL handles network rate limiting, connection pooling, and multi-tenant isolation without managed database costs. Details Docker implementation with tmpfs and config templating, shares 6-hour debugging journey (ProxySQL's SQLite gotcha on restarts), and monitoring approach for solo ops.

• •HAProxy handles network rate limiting (5 connections/IP, 10 new/3sec)
• •ProxySQL provides connection pooling and multi-tenant user routing
• •ProxySQL gotcha: uses SQLite DB after first boot, ignoring config changes (solved with tmpfs)

Generated with AI, which can make mistakes.