I created a short video on how to cluster a standalone PostgreSQL database in VMware Data Services Manager. PostgreSQL is a very popular virtualized workload to run on vSphere infrastructure. In this video, you will see how easy it is to create a clustered PostgreSQL database through VMware Data Services Manager (DSM) in just a few clicks. You will see how when a Read Replica is created, a PG_Monitor VM is also created. The PC_Monitor acts as a quorum or witness, and handles promotion of Read Replicas to primary role in the event of a failover. We will see how…
One the features of Data Services Manager (DSM) that stood out for me was how it could very easily make a standalone database highly available. With just a single click, users can deploy the necessary monitoring VMs (in the case of PostgreSQL, a PG_Monitor) and additional Read Only Replicas. In this post, I will show how to create a highly available database using DSM. I will highlight some of the requirements, and also some of what is taking place under the covers while the HA operation is in progress. Requirements Let’s begin by outline some of the requirements. The main…