An Ansible role, available via Ansible Galaxy, that installs and configures mysql on Ubuntu.
This role works with our repo to create a vagrant virtualbox vm, but is easily modifed to work with actual ubuntu boxes.
You'll probably want to amend / override:
defaults/main.yml
Preusming a requirements.yml as follows:
# Install a role from GitHub
- name: ansible-role-mysql
src: https://github.com/jcdarwin/ansible-role-mysql
We can install the role locally, using a requirements.yml file:
# Install a role from GitHub
- name: ansible-role-mysql
src: https://github.com/jcdarwin/ansible-role-mysql
path: roles/
Install the role:
ansible-galaxy install -r requirements.yml -p ./roles
You may already have:
- Created a vagrant VirtualBox virtual machine using ansible-roles-vagrant
- Provisioned the virtual machine with users using ansible-role-users
- Installled various common packages using ansible_role_common
Available variables are listed below, along with default values as found in defaults/main.yml:
ansible_role_mysql:
user: root
password: changeme
db: whatever
db_host: localhost
db_user: whatever
db_password: changeme
encoding: utf8
collation: utf8_unicode_ci
None.
Our hosts file, as generated by our repo to create a vagrant virtualbox vm:
[vagrant]
host1 ansible_ssh_host=127.0.0.1 ansible_ssh_port=2222 ansible_user=vagrant ansible_ssh_private_key_file=../.vagrant/machines/default/virtualbox/private_key
We include a playbook at main.yml.
Running the playbook:
# Note that we're presuming our hosts file has been generated by our vagrant repo
ansible all -m ping -i ../vagrant/ansible/hosts -l all
ansible-playbook -l all main.yml -i ../vagrant/ansible/hosts
# Check that our packages have been installed
ansible -m shell -a 'echo "show databases;" | mysql -u root -pchangeme' all -i ../vagrant/ansible/hosts
MIT