== Ansible Lab == In this lab, you will install and use Ansible to install MySQL/MariaDB and create database remotely. '''Requirements:''' Participants are requested to have a computer with Windows 8/10/11 (8GB RAM, 25GB free disk space) with Virtualbox (version 6 or higher) hypervisor and PuTTY installed.[[BR]] In Virtualbox, 'Extension pack' should be installed. A wired internet connection is preferred. [[BR]] '''Virtual Machine (VM) Setup''' Download VM from the following Link. https://docs.learn.ac.lk/index.php/s/YcojJ2544b40Zw4 Import the VM to Virtualbox.[[BR]] Username and Password: '''docker''' [[BR]] May have to create Virtualbox Host-Only Network Adapter[[BR]] {{{ File > Host Network Manager > Create }}} Test internet connectivity.[[BR]] Login using PuTTY. [[BR]] '''Setup Nodes''' ''In control node'' Login as root to the node and install Ansible {{{ apt install ansible }}} ''In each managed node'' Login as root to the node and install Ansible {{{ apt install python3.10 }}} '''Setup Passwordless SSH''' ''In each node'' Login as normal user. {{{ ssh user > ssh-keygen -t rsa }}} Continue by entering the prompts. ''In each managed node'' '''Create the Playbook - In control node''' '''Run the Playbook - In control node''' {{{ ansible-playbook .yml -e }}}