Ansible Role for MySQL VirtualHost

Ansible Role for MySQL 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	utf8_general_ci		Pass value as collation to mysql_db module.
mysql_vhosts_encoding	yes	utf8		Pass value as encoding to mysql_db module.
mysql_vhosts_id	yes	example		Unique ID for virtual host shared among other services.
mysql_vhosts_pass	yes	xaivoo9Z		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	example		Pass value as name to mysql_user module.

Dependencies

No additional role dependencies.

Example Playbook

- hosts: all
  roles:
    - role: hswong3i.mysql_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