Editor’s note: Today’s guest post is by Jeff McCormick, a developer at Crunchy Data, showing how to deploy a PostgreSQL cluster using Helm, a Kubernetes package manager.Crunchy Data supplies a set of open source PostgreSQL and PostgreSQL related containers. The Crunchy PostgreSQL Container Suite includes containers that deploy, monitor, and administer the open source PostgreSQL database, for more details view this GitHub repository. In this post we’ll show you how to deploy a PostgreSQL cluster using Helm, a Kubernetes package manager. For reference, the Crunchy Helm Chart examples used within this post are located here, and the pre-built containers can be found on DockerHub at this location. This example will create the following in your Kubernetes cluster:postgres master servicepostgres replica servicepostgres 9.5 master database (pod)postgres 9.5 replica database (replication controller)This example creates a simple Postgres streaming replication deployment with a master (read-write), and a single asynchronous replica (read-only). You can scale up the number of replicas dynamically.ContentsThe example is made up of various Chart files as follows:values.yamlThis file contains values which you can reference within the database templates allowing you to specify in one place values like database passwordstemplates/master-pod.yamlThe postgres master database pod definition. This file causes a single postgres master pod to be created.templates/master-service.yamlThe postgres master database has a service created to act as a proxy. This file causes a single service to be created to proxy calls to the master database.templates/replica-rc.yamlThe postgres replica database is defined by this file. This file causes a replication controller to be created which allows the postgres replica containers to be scaled up on-demand.templates/replica-service.yamlThis file causes the service proxy for the replica database container(s) to be created.InstallationInstall Helm according to their GitHub documentation and then install the examples as follows:helm initcd crunchy-containers/examples/kubehelmhelm install ./crunchy-postgresTestingAfter installing the Helm chart, you will see the following services:kubectl get servicesNAME CLUSTER-IP EXTERNAL-IP PORT(S) AGEcrunchy-master 10.0.0.171 <none> 5432/TCP 1hcrunchy-replica 10.0.0.31 <none> 5432/TCP 1hkubernetes 10.0.0.1 <none> 443/TCP 1hIt takes about a minute for the replica to begin replicating with the master. To test out replication, see if replication is underway with this command, enter password for the password when prompted:psql -h crunchy-master -U postgres postgres -c ‘table pg_stat_replication’If you see a line returned from that query it means the master is replicating to the slave. Try creating some data on the master:psql -h crunchy-master -U postgres postgres -c ‘create table foo (id int)’psql -h crunchy-master -U postgres postgres -c ‘insert into foo values (1)’ Then verify that the data is replicated to the slave:psql -h crunchy-replica -U postgres postgres -c ‘table foo’You can scale up the number of read-only replicas by running the following kubernetes command:kubectl scale rc crunchy-replica –replicas=2It takes 60 seconds for the replica to start and begin replicating from the master. The Kubernetes Helm and Charts projects provide a streamlined way to package up complex applications and deploy them on a Kubernetes cluster. Deploying PostgreSQL clusters can sometimes prove challenging, but the task is greatly simplified using Helm and Charts.–Jeff McCormick, Developer, Crunchy DataDownload KubernetesGet involved with the Kubernetes project on GitHub Post questions (or answer questions) on Stack Overflow Connect with the community on SlackFollow us on Twitter @Kubernetesio for latest updates
Quelle: kubernetes
Creating a PostgreSQL Cluster using Helm
Published by