odyssey 试用
以下是odyssey 的一个试用
环境准备
- docker-compose 文件
version: "3"
services:
postgres:
image: postgres:12
ports:
- "5432:5432"
environment:
- "POSTGRES_PASSWORD=dalong"
pgbouncer:
image: brainsam/pgbouncer
ports:
- "6543:6543"
volumes:
- "./pgbouncer.ini:/etc/pgbouncer/pgbouncer.ini"
- "./users.txt:/opt/auth/users.txt"
app:
image: kksudo/odyssey-docker:1.1
ports:
- "6432:6432"
volumes:
- "./odyssey-dev.conf:/etc/odyssey/odyssey.conf"
- 说明
环境包含了pgbouncer以及odyssey，配置说明
pgbouncer.ini
[databases]
postgres = host=postgres port=5432 auth_user=postgres
[pgbouncer]
listen_addr = 0.0.0.0
auth_type = md5
auth_file = /opt/auth/users.txt
listen_port = 6543
ignore_startup_parameters = extra_float_digits
verbose = 2
admin_users = postgres
odyssey.conf
daemonize no
unix_socket_dir "/tmp"
unix_socket_mode "0644"
log_format "%p %t %l [%i %s] (%c) %m\n"
log_to_stdout yes
log_syslog no
log_syslog_ident "odyssey"
log_syslog_facility "daemon"
log_debug yes
log_config yes
log_session yes
log_query no
listen {
host "*"
port 6432
backlog 128
}
storage "postgres_server" {
type "remote"
host "postgres"
port 5432
}
database default {
user default {
authentication "md5"
storage "postgres_server"
pool "transaction"
pool_size 0
pool_timeout 0
pool_ttl 60
password "md5f293e70a2114bd91a4a1203a5f0548cd"
pool_discard no
pool_cancel yes
pool_rollback yes
client_fwd_error yes
application_name_add_host yes
server_lifetime 3600
log_debug no
quantiles "0.99,0.95,0.5"
}
}
storage "local" {
type "local"
}
database "console" {
user default {
authentication "none"
pool "session"
storage "local"
}
}
访问
我们可以通过 127.0.0.1 6543 postgres dalong 以及6432 端口，odyssey 是一个很不错的选择，同时配置上还是比较清晰的
参考资料
https://github.com/yandex/odyssey/blob/master/documentation/configuration.md#example-1
https://www.pgbouncer.org/
https://github.com/rongfengliang/postgres-connect-pool-tools-learning
