search

yandex / odyssey

Scalable PostgreSQL connection pooler
BSD 3-Clause "New" or "Revised" License
3.17k stars 160 forks source link

Leader Failover #44

Open bpicolo opened 5 years ago

bpicolo commented 5 years ago

I'm looking into potentially deploying odyssey as a proxy for traffic from golang and I'm wondering if there's any possibility of supporting leader failover.

The issue I've hit is that both libpq and jdbc drivers support something like target_session_attrs that allow the drivers to understand leader failover.

Is this something that's possible with odyssey right now (and otherwise, what might it take to support it?)? Unfortunately, the golang driver also doesn't support this right now so I'm in something of a bind. :)

pmwkaa commented 5 years ago

Currently Odyssey does not support it, but we have discussed that it could be a great feature and likely will be implemented in future. I also share the same thoughts, I think this is a right direction for future development :)