HeliosProxy vs MariaDB MaxScale

HeliosProxy is a self-hosted, programmable PostgreSQL data-plane for routing connections, handling failover, replaying traffic, and supporting database upgrades. It provides session, transaction, and statement pooling, with multiplexing up to 100:1. Routing can account for replica lag, workload type, and failing backends through circuit breaking. Cache options include local memory, Redis-backed storage, and semantic tiers, with invalidation when writes occur. Transaction Replay can move sessions to a new primary and optionally replay reads or transactions when conditions permit, although prepared statements, temporary tables, open cursors, advisory locks, and extended-protocol SET statements are not restored. A WebAssembly plugin runtime offers five hook points, Ed25519 verification, and OCI distribution. The admin console includes topology, plugin, chaos, shadow-execution, and traffic-replay panels. Authentication supports JWT, OAuth 2.0, LDAP, and API keys. HeliosProxy works with PostgreSQL 12+ and compatible databases, and deployment documentation covers Docker, Kubernetes, and standalone setups. It is open source under Apache 2.0 and costs nothing.

MariaDB MaxScale has no write-up on Specifiction yet; its figures are above.