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…