DBLE vs Pgpool-II

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.

Pgpool-II is free, self-hosted middleware positioned between PostgreSQL servers and database clients. It relays PostgreSQL protocol messages, reuses matching server connections to reduce overhead, and distributes SELECT queries across replicated databases. High-availability functions include automatic failover, Watchdog, quorum, and split-brain prevention. Additional features include replication, online recovery, connection limiting, and an in-memory query cache. The project is available in binary and source formats, including RPM packages for Red Hat Enterprise Linux and compatible distributions; Debian and Ubuntu users are directed to PostgreSQL community packages. Authentication supports trust, clear-text password, MD5, SCRAM-SHA-256, certificates, PAM, and LDAP, but not GSSAPI. SSL can protect frontend and backend traffic when enabled; it is off by default and requires OpenSSL support. Community assistance is available through mailing lists and GitHub Issues, while SRA OSS K.K. offers commercial support, consulting, and integration. The license permits use, modification, copying, and distribution without a fee.