Odyssey team is pleased to announce the release of Odyssey 1.1, a scalable multi-threaded connection pooler for
PostgreSQLdesigned for the cloud.
In this release we introduced several settings. These settings are intended to tune compatibility with PgBouncer
workloadhandling.
Now you can control in config:
• server lifetime - prevents bloat of caches for long lasting server connections
• server max routing - prevents too fast server connection allocation
• server login retry timeout - adds delay between unsuccessful server connections
• client login timeout - prevents denial of servers due to hanging clients
• add host to application_name - helps to diagnose various problems
Bugs fixed:
• Incorrect handling of GSSAPI request
• Incompatibility of show clients, show server, show databases with PgBouncer
• Incorrect Cancel handling (was expecting TLS connections, which is not necessary in protocol)
• Counting of free servers currently is exactly the same as in PgBouncer
Features added:
• Odyssey now computes query\transaction time quantiles within stat period
• In session pooling mode client allocates server connection only when it is required.
Breaking change:
Replication storage types are now deprecated. When client asks regular storage for logical\physical replication
connection,Odyssey will ask database if it is allowed and handle connection transparently.
We appreciate any kind of feedback and contribution to the project.
Odyssey releases can be found at
https://github.com/yandex/odyssey/releases
Thanks!
--
Andrey Borodin
Open source RDBMS development team leader
Yandex.Cloud