DBLE vs Odyssey
DBLE
opensource.actionsky.comOdyssey
pg-odyssey.techSide by side
| Figure | DBLE | Odyssey |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| macOS | — | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 0 |
| Spec score · Database Proxy Software | 7.8 (#7) | 7.5 (#17) |
| Purpose | DBLE is high-scalability middleware for MySQL sharding. | Odyssey is an advanced, multithreaded PostgreSQL connection pooler and request router. |
| Support | The DBLE documentation lists community support resources and says commercial support is available by contacting the maker. | Users can report issues on the project page or ask usage and development questions in the Telegram community; the project says responses may not be quick. |
Plans
In their own words
DBLE
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.