How to install MariaDB using Ansible Playbook on Ubuntu - TechBeginner

Welcome to, Tech Beginner provides technical blog for Online Linux Tutorials, Ubuntu Tutorials, Redhat Tutorials and CentOS 7, Configuration of server like Web Server, Application server, Database server, Window server, networking, html, css, java script, php, wordpress, opencart, magento, joomla and etc.

How to install MariaDB using Ansible Playbook on Ubuntu

Share This


Some time we need to automate the packages installation on multiple server, Here we are about to create Ansible Playbook to install MariaDB server


We believe, You have already installed Ansible if not you need to click on given link to install Ansible on ubuntu server. 


Step 1: Configure Ansible 


By default ansible host configuration file is /etc/ansible/hosts Here you need to add the MariaDB server details like this, Use the following step for the same, In my case i have 1 MariaDB database server.


Group Name  - Database

IP Address     - Your IP Address

Username      - example

Password       - XXXXXXXXXX

You need to add your server in ansible host file, Syntax is given below, You need to open the /etc/ansible/hosts file with nano or vim text editor.

©sudo vim /etc/ansible/hosts

and add the web server entry like this.

localhost ansible_connection=ssh ansible_ssh_user=ubuntu ansible_ssh_pass=xxxxxxx


Change the credentials as per your environment, Save and exit from the vim text editor and verify the host machine connectivity with ansible by using the given command.

©©ansible all -m ping

You should get output like this.



Here our host configuration is completed and now we can go for next step to write play book.


Step 2: Creating Apache Playbook


You need to create a mariadb-playbook.yml and you change it according to your requirement.

©©sudo vim mariadb-playbook.yml

Paste the given code.

- hosts: database
become: yes

- name: Install MariaDB repository 10.3
apt_repository: repo='deb [arch=amd64] xenial main' state=present

- name: Add repository key to the system
apt_key: keyserver=hkp:// id=0xF1656F24C74CD1D8

- name: update
apt: update_cache=yes
ignore_errors: yes

- name: Install MariaDB Server 10.3
apt: name=mariadb-server state=latest

- name: Install MariaDB Client 10.3
apt: name=mariadb-client state=latest

- name: Restart MariaDB 10.3
service: name=mysql state=restarted

Now we are ready to use the mariaDB's PlayBook, To execute the PlayBook you need to use the given command.

©©ansible-playbook mariadb-playbook.yml

1 comment:

  1. Nice article,
    but 'add repository' should be added before MariaDB install. Otherwise install will not work.