Odyssey team is pleased to announce the release of Odyssey 1.1, a scalable
multi-threaded connection pooler for PostgreSQL designed for the cloud.
In this release we introduced several settings. These settings are intended to
tune compatibility with PgBouncer workload handling.
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
