Odyssey

Multi-threaded PostgreSQL connection pooler and request router with per-route pooling rules.

Provider: default
Kind: Database proxy
Category: Data
Official docs: https://github.com/yandex/odyssey/blob/master/docs/configuration/rules.md

Properties · 2 set by this component

property	type	values	required	kind default	this component
clientMax · component property	integer	—	no	0	inherited
hedging · advanced	boolean	—	no	false	inherited
loadShedding · advanced	boolean	—	no	false	inherited
managed	boolean	—	no	false	inherited
poolMode · component property	enum	session \| transaction	yes	—	inherited
poolSharded · advanced	boolean	—	no	false	inherited
poolSize · component property	integer	—	no	0	inherited
pooling	boolean	—	no	true	▸ true
requestCoalescing · advanced	boolean	—	no	false	inherited
routing	enum	none \| shard-key \| lookup	no	none	▸ none
scatterGather · advanced	boolean	—	no	false	inherited
targetSessionAttrs · component property	enum	any \| read-write \| read-only \| prefer-standby	no	—	inherited
workers · component property	integer	—	no	—	inherited

Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.

Use it in a design

nodes:
  - { id: "odyssey", component: "odyssey" }

Other Database proxy products · 13

Amazon RDS Proxyrds-proxyawsdatabase-proxy Cloudflare Hyperdrivecloudflare-hyperdrivecloudflaredatabase-proxy Generic database proxydatabase-proxydatabase-proxy MariaDB MaxScalemaxscaledatabase-proxy mongosmongosdatabase-proxy PgBouncerpgbouncerdatabase-proxy PgCatpgcatdatabase-proxy Pgpool-IIpgpooldatabase-proxy ProxySQLproxysqldatabase-proxy Supavisorsupavisordatabase-proxy Vitessvitessdatabase-proxy Cloud SQL Auth Proxygoogle-cloud-sql-auth-proxygcpdatabase-proxy IBM Data Virtualizationibm-data-virtualizationibmdatabase-proxy

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# Odyssey: multi-threaded PostgreSQL connection pooler and request router from Yandex.
3# Rules configuration: `pool` is required with no default, pool_size and client_max
4# default to 0 (unlimited), target_session_attrs picks primary or standby storage hosts.
5schemaVersion: "1"
6type: "component"
7id: "odyssey"
8kind: "database-proxy"
9provider: "default"
10docs: "https://github.com/yandex/odyssey/blob/master/docs/configuration/rules.md"
11defaults:
12  pooling: true
13  routing: "none"
14properties:
15  poolMode:
16    type: "enum"
17    values: ["session", "transaction"]
18    required: true
19  poolSize:
20    type: "integer"
21    default: 0
22  clientMax:
23    type: "integer"
24    default: 0
25  targetSessionAttrs:
26    type: "enum"
27    values: ["any", "read-write", "read-only", "prefer-standby"]
28  workers:
29    type: "integer"

The same page as markdown, for an agent: /catalogue/components/odyssey.md