This is another short video showing the main steps to configure Aria Operations (formerly vRealize Operations) to monitor databases provisioned via VMware Data Services Manager (DSM). Note that there is a requirement to install True Insight Management Packs for PostgreSQL (and MySQL) with Aria Operations. Thus, there may be a licensing cost associated with this. However, if you are already using Aria Operations as your single pane of glass for monitoring all of your vSphere Infrastructure, then there may be benefits to using the same mechanism to monitor your databases. The purpose here is to demonstrate that provisioning databases via…
In this post, I want to look at how VMware Data Services Manager v1.5 implements backup, restore and recover operations. I also want to highlight the difference between a restore operations and a recover operation since they are significantly different. We will look at these operations from the point of view of the different databases which are available in DSM, namely PostgreSQL, MySQL and MS SQL Server for Linux. Restore vs. Recover Let’s begin with a discussion on the differences between a restore and a recover in VMware DSM. The most significant difference is that a restore operations recovers the…
In my most recent post on VMware Data Services Manager (DSM), we saw how it was possible to integrate the PostgreSQL databases – which are deployed by VMware DSM – with Aria Operations. In this post, we will see how it is also possible to integrate the logs generated by these deployments into Aria Operations for Logs, formerly known as vRealize Log Insight. Let’s begin the post by once again sharing the versions of the various products that we will be using to do the setup. VMware vRealize® Operations™, Version: 8.10.2 (21178503), Edition: Enterprise vRealize True Visibility Management Pack for…
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…
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…