vRealize Aria Automation (formerly vRealize Automation) Database as a service (Without internet connectivity) using Red hat Ansible Tower, Git Lab and HTTPD.

Deploying and configuring VRA 8 – https://kdinesh.in/vrealize-automationvra/

Deploying Ansible Tower – https://docs.ansible.com/ansible-tower/latest/html/quickinstall/

Deploy Redhat 9.2 VM on vSphere and convert into the template and create image mapping in VRA

Deploy a Linux VM and configure HTTPD and Copy MariaDB repo files (Command to download repo files – wget -np -r -l 2 Repo URL)

Deploy Git Lab community version (You can check official gitlab doc ).

Ansible Tower Integration with VRA, VRA Cloud template configuration, Ansible Playbook and GitLab Configuration and Testing deployment: –

Login to VRA > Cloud Assembly> Infrastructure > Integration. Select Ansible Tower and add the required details.

You can Download Cloud template – https://github.com/Dineshk1205/vraAnsibleDB/blob/main/Redhat_Mariadb.yaml

Update Tags in cloud template according to your environment tags.

Crate a project in gitlab and Upload Ansible playbooks files.

Playbooks download Link – https://github.com/Dineshk1205/vraAnsibleDB/tree/main

Update Repo URL based on your environment.

Login to Ansible Tower, create a new project, Select SCM type Git and add SCM URL as GITHUB URL and select Update Revision on launch option and save,

Create Credentials. Select Credential type machine add REDHAT template username and password, Save.

Create Three Templates Mariadb11-0, MariaDB10-11, MariaDB10.10 ( Use following template names, if your using a different template names update the cloud templates according to template names)

Configuration completed. Publish VRA Cloud assembly template to Service Catalog and Test Deployment.

Login to VRA Service Broker. Select catalog item, Click on Request.

Select Project and Flavor and Version from the drop down list, enter deployment name , submit. Based on MariaDB input Ansible will run playbook.

Approx. it will take 15 to 20 min (Based on infra time may vary) for provisioning and configuring the VM.

Deployment completed successfully

Login and check VM. Ansible deployed MariaDB 11.0 and it’s running.

Check in Ansible tower, In the host list VM added .

MariaDB playbook job status is successful