DBLE vs pgagroal

DBLE is free, open-source middleware for scaling MySQL through sharding. It uses the MySQL protocol and can replace MySQL in many cases without application code changes. Teams can configure hash, modulo, time-based, range-based, or custom sharding, along with global and ER tables. DBLE lists query routing, connection pooling, load balancing, automatic failover, read/write separation, master-slave expansion, and ZooKeeper cluster deployment. SQL support includes SQL 92 and MySQL dialect features such as joins, unions, grouping, ordering, and distinct queries; some features remain on its roadmap. Query optimization addresses global-table joins, sharded tables, ER relations, and subqueries. Distributed transactions use two-phase commit in normal or XA modes, with XA depending on MySQL 5.7 XA transactions, backend availability, and disk reliability. Security controls include password encryption, IP allowlists, and SQL denylists. Explain plans, MySQL-compatible slow logs, and slow-query reports support operations. DBLE is self-hosted on Linux and GPL-2.0 licensed. The open-source plan costs nothing.

pgagroal is a free, self-hosted PostgreSQL connection pool for Linux and macOS. It supports per-user and per-database connection limits, pool prefill, idle connection removal, and connection validation. Administrators can enable or disable database access and choose graceful or fast shutdown. Remote management and command-line tools handle runtime administration and user management. Monitoring exports Prometheus metrics and includes a Grafana 12 dashboard. Authentication can use database-backed queries or a user vault for credentials. If a PostgreSQL server can no longer accept writes, pgagroal can trigger an external failover workflow. The project lists TLS v1.2+ and describes both server-only and mutual certificate authentication. It works with PostgreSQL-compliant drivers including pgjdbc, Npgsql, and pq. Tested systems listed include Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD; releases list packages through Fedora 42/43, RHEL 10, and Rocky Linux 10. The repository identifies a BSD-3-Clause license. GitHub is used for questions, issues, feature requests, and code contributions.