Feature parity with proxies

[mostafa]

Note that some of the following features are going to be implemented using plugins.

Proxies

• PgBouncer
  • Features:
    • Connection pooling methods: https://github.com/gatewayd-io/gatewayd/issues/55
      • Session pooling (the current method)
      • Transaction pooling
      • Statement pooling
    • Online reconfiguration:
      • https://github.com/gatewayd-io/gatewayd/issues/300
      • https://github.com/gatewayd-io/gatewayd/issues/270
    • Online restart/upgrade without dropping client connections: https://github.com/gatewayd-io/gatewayd/issues/297
    • Startup parameter detection (database is detected for now)
    • Authentication
    • TLS: https://github.com/gatewayd-io/gatewayd/issues/168
    • https://github.com/gatewayd-io/gatewayd/issues/205
    • SQL feature support:
  • Cloudflare's fork of PgBouncer
• Odyssey
• PgCat
  • Load-balancing of read queries
  • Failover
  • Sharding:
    • Extended SQL query
    • Comments-based/regex
    • Automatic sharding key detection
  • Mirroring
• PgPool-II
  • Replication
  • Watchdog
• supavisor
  • Manageable:
    • https://github.com/gatewayd-io/gatewayd/issues/181
    • https://github.com/gatewayd-io/gatewayd/issues/222
    • https://github.com/gatewayd-io/gatewayd/issues/167
    • https://github.com/gatewayd-io/gatewayd/issues/187
    • https://github.com/gatewayd-io/gatewayd/issues/186
• stolon
  • Streaming replication
  • Partitioning
  • k8s support
  • Replication:
    • Sync
    • Async
• crunchy-proxy
  • Healthcheck
• pgagroal

Tasks

• [ ] Create tickets for different feature in different projects and repos
• [ ] Test for performance and reliability

Resources

• https://tech.instacart.com/adopting-pgcat-a-nextgen-postgres-proxy-3cf284e68c2f