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: Add connection multiplexing to avoid 1:1 mapping of client to server connections #55
      • Session pooling (the current method)
      • Transaction pooling
      • Statement pooling
    • Online reconfiguration:
      • Config management without restart #300
      • Add self update command #270
    • Online restart/upgrade without dropping client connections: Hotswap updates #297
    • Startup parameter detection (database is detected for now)
    • Authentication
    • TLS: TLS termination #168
    • Support controlling commands (like PgBouncer) #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:
    • Extend Admin API #181
    • Implement xDS APIs #222
    • Query API #167
    • Add metrics to API #187
    • Add tracing to API #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