Installing and configuring MariaDB on RHEL 8 using Ansible Automation
We will start with the inventory file to set up the MariaDB servers and configure them with users. We will then go into manipulating data within the created MariaDB system using loops to add things such as tables and database entries. We will then use Ansible Automation to show how to retrieve information from the MariaDB database so that you can provide information from your database to end users. Please ensure that the server you are running this playbook against has not had MariaDB installed previously, or you will receive errors when trying to set the root password.
First, we are going to start with an inventory file, which can be seen in the following screenshot:
Figure 7.22 – Ansible Automation inventory file
From there, we are going to create the ansible.cfg file within our directory so that we can skip host_key_checking, as it causes issues with connectivity. We can...
