Configuring Clustered MySQL in VMware Data Services Manager (Video)

In this video, you will see how easy it is to create a clustered MySQL database through VMware Data Services Manager (DSM) v1.4. The video shows how to deploy a clustered MySQL database at deployment time rather than building a standalone MySQL database and then enabling a clustered configuration. You will see how a ‘clustered’ IP address is used to act as a front-end IP address for the cluster, and also how a read-write access port of 6446 is used to connect to the database rather than the default port of 3306. Finally, you will see how to use the…

Self-Service Database Clone in VMware Data Services Manager (Video)

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…

Self-Service Database Backup & Restore in VMware Data Services Manager (Video)

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…

Lifecycle Management in VMware Data Services Manager (Video)

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.

Lifecycle Management (v1.3.2 to v1.4) in VMware Data Services Manager

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…

Configuring HA for PostgreSQL in VMware Data Services Manager (Video)

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…