This one click deployment of a Highly-Available PostgreSQL Cluster on Azure has automated replication, server management and leader election. This project contains a modified deployment version of Haufe's blog post.
This Azure template generates two sets of machines both running Ubuntu 16.04 LTS. The first set of three machines are used to run the distributed configuration store ZooKeeper, while the second set is running PostgreSQL 9.6 together with Patroni providing a high-availability customizable PostgreSQL cluster deployment. This deployment also includes PL/V8 v.2.0.0.
This template provides the following parameters, so you can customize your deployment to your needs:
-
clusterName: What your cluster will be named.
-
_artifactsLocation: The repo name from which you are deploying. Default("https://raw.githubusercontent.com/HelloTech/azure_postgres/master")
-
newVnet: Whether or not you want to create a new vnet. Default("yes")
-
vnetGroup: The resource group in which the vnet is located. If you select yes on newVnet this needs to be set to the resource group in which you are deploying.
-
lbType: Whether you want to create an external or internal load balancer. If set to internal the load balancer will only be accessible from inside the virtual network. Default("internal")
-
vnetName: If newVnet is set to yes, this will be name of the created vnet. Otherwise, this is the name of already existing vnet to which the deployment will be associated.
-
zookeeperNetName: If newVnet is set to yes, this will be name of the created subnet for the zookeeper machines, otherwise this is the name of already existing subnet that will contain the zookeeper vm's.
-
postgresNetName: If newVnet is set to yes, this will be name of the created subnet for the postgres machines, otherwise this is the name of already existing subnet that will contain the postgres vm's.
-
zookeeperVMSize: The size of zookeeper vms.
-
postgresVMSize: The size of the postgres vms.
-
postgresDataSize: The size of the ssd used for pg_data for the postgres vms.
-
instanceCount: The number of postgres vms.
-
adminUsername: The Ubuntu username.
-
adminPassword: The Ubuntu password.
The creation of the zookeeper instances is handled by the zookeeper_startup.sh script. If you would like to make any changes to what is installed on those vm's modify this file.
The mounting of the data ssds is handled by the autopart.sh script.
The creation of the postgres instance is handles by the postgres_startup.sh script. If you would like to make any changes to what is installed on those vm's modify that script.
This deployment can take anywhere from 90 to 120 minutes to complete due to long build time for plv8.
Released under the MIT license. See the LICENSE file for more info.