k8s pgbouncer

deploy pgbouncer in k8s gke with configmap for list user and endpoint database

push dokcer images pgbouncer to container registry

docker build --no-cache -t zeus-pgbouncer .
docker tag zeus-pgbouncer asia.gcr.io/zeus-007/zeus-pgbouncer:v1
docker push asia.gcr.io/zeus-007/zeus-pgbouncer:v1

deploy pgbouncer to k8s gke

kubectl apply -f configmap-staging-pgbouncher.yaml

kubectl apply -f deployment-staging-pgbouncer.yaml

Test pgbench for 60 second, 100 client, select only

Cloud SQL Postgresql 11, 4 Core 6GB RAM

pgbench -i -h 10.248.11.223 -U postgres postgres

pgbench -h staging-pgbouncer -c 100 -T 60 -S -n -U postgres postgres

transaction type: <builtin: select only>
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
duration: 60 s
number of transactions actually processed: 2051225
latency average = 2.926 ms
tps = 34180.975763 (including connections establishing)
tps = 34181.812447 (excluding connections establishing)