This short video steps through the cloning of an existing database, highlighting another self-service feature of VMware Data Services Manager. This task can be done directly in the DSM UI by an end user, adding to the self-service capabilities available in the product. The demo will show how to take the clone, and then uses pgAdmin 4 to connect to the databases, validate the results of the cloning operation (by looking at the schema and tables), and then examining the contents of one of the cloned tables. Hope you find it useful. Please reach out with any thoughts, comments or…
In this short video, one of the really nice self-service features of VMware Data Services Manager is demonstrated. In the video, we see how someone with the role of an Org Administrator is able to build databases, and then give ownership to some end-users, possibly a developer. We will then see how this end user can consume the database, whilst also carrying out important tasks such as on-the-fly backups whenever the database has some critical data added. Finally, we will see how this same end-user can initiated a restore of the database from a particular point in time (PIT) if…
This is a short video which highlights the various aspects of lifecycle management in VMware Data Services Manager (DSM). The demo shows the steps involved in upgrading DSM from v1.3.2 to v1.4. It looks at the steps to upgrade the Provider, the Agents and the version of existing databases which are already deployed. It also highlights points where these updates can be automated from within DSM itself, along with maintenance windows and policies. A more detailed description of the steps are highlighted in this accompanying lifecycle management blog post which covers the same upgrade scenario.
In this post, three aspects of lifecycle management of VMware Data Services Manager are reviewed. An upgrade from DSM v1.3.2 to v1.4 will be used to demonstrate the various aspects of lifecycle management. First, the provider administrator will upgrade the DSM provider. This will be followed by an upgrade of the DSM agents, before finally upgrading the databases. Upgrading from DSM v1.3.2 to v1.4 introduces a new minor version of the supported versions of PostgreSQL and MySQL. If the Allow Minor Version Upgrade option is enabled, then the databases are updated during the next maintenance slot automatically. However, the provider…
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…
I continue my journey to learn more about VMware Data Services Manager (DSM). Today, I turn my attention to clustering MySQL to make it highly available on vSphere infrastructure. This is subtlety different to the previous exercise of enabling HA on PostgreSQL. With the MySQL HA implementation, there is no requirement to deploy an additional VM to behave as the witness/quorum such as the PG_Monitor in the case of PostgreSQL. To make MySQL highly available, MySQL InnoDB Cluster is used. This utilizes a feature called group replication to synchronize the different read replicas. It also supports the concept of a…
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…