Ansible MySQL Role

---

This is an Ansible role that will provision a fresh mysql/mariadb server installation.

More Documentation

---

clusterfrak.com

Requirements

---

1.    Install dependencies:

RedHat based distros (RHEL, CentOS):

sudo yum -y install epel-release
sudo yum clean all
sudo yum -y install ansible

3.    Create directory structure:

Create the directory structure that you are going to use. In this tutorial we are going to set up ansible roles in /etc/ansible/roles

mkdir -p /etc/ansible/roles || exit 0

4.    Set ansible host:

Set Ansible localhost entry so that ansible knows it will run against localhost and can talk to itself on localhost without attempting to open a TCP socket connection.

echo localhost ansible_connection=local > /etc/ansible/hosts

Dependencies

---

No other roles required in order to run this role

Example Playbook With Default Values

---

This playbook will set up MySQL/Mariadb, it will deploy and maintain the my.conf and file. It will set the my.conf file to listen on the default IP address instead of localhost.

- hosts: mysql-servers
  become: true
 roles:
   - clusterfrak.mysql

License

---

BSD

Author Information

---

Rich Nason
Clusterfrak Doc Site
Container Doc Site