I have been using Aria Operations and True Visibility Management Packs quite a bit recently. This is mostly to get visibility into databases that are being provisioned by VMware Data Services Manager (DSM). I just learnt that we released a bunch of new Management Packs (v9.1) only last week, including updated Management Packs for both PostgreSQL and MySQL. In this post, I will deploy a new PostgreSQL database via Data Services Manager (DSM) 2.0, add the necessary database configuration options and extensions, and then add the database to Aria Operations True Visibility for PostgreSQL databases for monitoring. You might ask…
I have created a new video showing how to create an PostgreSQL database in Data Services Manager (DSM) version 2.0. The objective is to show how simple it is to not only deploy a database, but also how the provisioning steps allows different vSphere infrastructure resources to be selected during the provisioning stage. This is achieved through Infrastructure Policies which we learnt about in the previous video. The demo also touches on features such as automated backups, automated lifecycle management and advanced settings, all of which may be configured at database deployment time.
So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy a Data Service via Data Services Manager (DSM) 2.0. The data service in question is PostgreSQL, an open-source database which our telemetry tells us is a very popular database deployed on vSphere infrastructure by our customers. Let’s examine the steps involved in deploying PostgreSQL via the DSM UI, whilst also noting that DSM has a very rich API allowing deployment of these data services via various automation…
I had an interesting query earlier this week in relation to PostgreSQL Extensions in VMware Data Services Manager (DSM) v1.5. We do not give out superuser (postgres user) privileges when creating databases via DSM, although it is still possible to find those credentials and access the database with those privileges if necessary. Instead, we focus on the default user that we create when we deploy a database, a user that we have named ‘dbaas’. The query was how should extensions be added to PostgreSQL if ‘dbaas’ is not a superuser? The answer lies in our DSM documentation where we describe…
This is a post to address a query that I recently received regarding the use of Aria Operations (formerly vRealize Operations) with VMware Data Services Manager. The question was whether or not the vRealize True Visibility Suite for PostgreSQL and MySQL would work with the databases that are provisioned by DSM. tl;dr The answer is yes, the True Visibility management packs will successfully gather metrics from databases deployed via DSM, and allow you to build monitoring dashboards, etc. In this post, I will demonstrate the steps involved in configuring the integration for PostgreSQL as there are a few specific steps…