MariaDB is a relational database management system fork developed by the community and commercially supported under the GNU General Public License. It is intended to remain free and open-source software.
Ansible is a collection of software tools that let infrastructure be written in code. Software provisioning, configuration management, and application deployment are all included in the open-source suite.
- Up and running Ansible server.
- Root access of target machine.
- Internet connectivity with nodes.
We’ll show you how to use the Ansible automation tool to install the MariaDB Database server on a Ubuntu machine in this post.
Step 1: Creating MariaDB Playbook
We need to create a
mariadb-playbook.yml, Ansible play is very import to to execute the task one by one.
To create a
Paste the following code.
- name: Install MariaDB hosts: mariadbservers become: true tasks: - name: Update apt-get repo and cache apt: update_cache=yes force_apt_get=yes cache_valid_time=3600 - name: Install MariaDB apt: name: mariadb-server state: present - name: Start MariaDB service: name: mariadb state: started enabled: yes
Save and exit from the text editor, This playbook does the following:
- Adds the MariaDB repository to the remote server.
- Imports the MariaDB GPG key.
- Installs MariaDB.
- Starts the MariaDB service and enables it to start automatically on boot.
Note that this is just one example, and the specific details of your playbook will depend on your use case and the specific version of MariaDB you’re using
Step 2: Execute MariaDB Playbook
We are good to execute the
mariadb-playbook.yml by following the given command.
The above command start the installation of MariaDB database server on target machine.
Step 3: Testing MariaDB
We need to execute the
sudo mysql to take mysql shell access, Use the following steps for the same.
To Login MariaDB.
You should get output like this.
We have successfully installed MariaDB Database server on Ubuntu 22.04 LTS with ansible. If you still have any questions, please leave a comment below: