Deploying PostgreSQL Cluster with Query Load Balancing and Monitoring Capabilities on Kubernetes
Presented by:
Bo Peng
Bo Peng is a chief engineer at SRA OSS, Inc. Japan.
She is in charge of open source software technical support and is also a developer of Pgpool-II. In Pgpool-II project, besides working on new features and bug fixes, she is responsible for release management and document management.
No video of the event yet, sorry!
Kubernetes is an open source container orchestration platform for automating deployment, scaling and management of application containers. Nowadays, more and more applications are being deployed in containers on Kubernetes.
There are several solutions that can help us to run a PostgreSQL cluster on Kubernetes. However, these solutions don't provide query load balancing capability.
In this talk, I will show you how to combine PostgreSQL Operator with Pgpool-II to deploy a PostgreSQL cluster with query load balancing capability on Kubernetes.
Monitoring is a very important part in production environments. Although Kubernetes provides a basic way to monitor the status of a PostgreSQL cluster, this is not sufficient for managing a PostgreSQL cluster in production. An important improvement of Pgpool-II 4.2 release is the ability to output more useful statistics of the PostgreSQL cluster.
In this talk, I will describe how to monitor and visualize the PostgreSQL cluster statistics in Prometheus for extensive cluster monitoring.
- Date:
- 2020 November 20 14:10 CST
- Duration:
- 40 min
- Room:
- Virtual - English Main Conference
- Conference:
- CHINA 2020 And PGConf.Asia 2020
- Language:
- Track:
- Everything about Postgres
- Difficulty:
- Medium