Ansible Role for MariaDB VirtualHost

Ansible Role for MariaDB VirtualHost Management.

Requirements

This role require Ansible 2.0 or higher.

This role was designed for Ubuntu Server 14.04 LTS and Ubuntu Server 16.04 LTS.

Role Variables

parameter	required	default	choices	comments
mysql_vhosts_collation	yes	utf8mb4_general_ci		Pass value as collation to mysql_db module.
mysql_vhosts_encoding	yes	utf8mb4		Pass value as encoding to mysql_db module.
mysql_vhosts_id	yes			Unique ID for virtual host shared among other services.
mysql_vhosts_pass	yes			Pass value as password to mysql_user module.
mysql_vhosts_privs	yes	defaults/main.yml	[] list	Pass list to mysql_user module.
mysql_vhosts_user	yes			Pass value as name to mysql_user module.

Dependencies

No additional role dependencies.

Example Playbook

- hosts: all
  roles:
    - role: hswong3i.mariadb_vhosts
      mysql_vhosts_id: "example"
      mysql_vhosts_pass: "xaivoo9Z"
      mysql_vhosts_user: "example"

License

• Code released under MIT
• Docs released under CC BY 4.0

Author Information

• Wong Hoi Sing Edison
  • https://twitter.com/hswong3i
  • https://github.com/hswong3i