Skip to content

[Feat] Add ProxySQL support as a modern Layer 7 alternative to HAProxy + PgBouncer #1533

@prensgold

Description

@prensgold

Hi Autobase team. I would like to propose adding ProxySQL support to the Autobase ecosystem as a modern Layer 7 alternative to the traditional HAProxy + PgBouncer stack. With ProxySQL's recent native support for the PostgreSQL wire protocol, integrating it would bring massive architectural advantages to the platform, including out-of-the-box read/write splitting on a single port, multi-threaded connection multiplexing that scales far better than PgBouncer, and graceful failover mechanisms that hold client connections in a queue instead of dropping them when the primary changes. Given its advanced day-2 traffic control capabilities—like real-time query rewriting, caching, and throttling without application changes—offering ProxySQL would significantly elevate Autobase's enterprise-grade DBaaS experience. Would the core team consider implementing this or accepting PRs for it? Thank you!

Importance

nice to have

Proposed implementation

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions