local.db.yml

---
- name: Install Drupal and Drush with MariaDB, Nginx, and PHP-FPM
  hosts: 127.0.0.1
  connection: local
  remote_user: vagrant
  become: yes

  vars:
  
    mysql_root_password: 'my_secure_pass'
    mysql_bind_address: private_mysql_server_ip
    query_cache_limit: 4M
    query_cache_size: 256M
    key_buffer_size: 128M
    long_query_time: 2
    myisam_sort_buffer_size: 128M
    innodb_buffer_pool_size: 2G
    innodb_log_file_size: 512M
    
    dbs:
      drupal8:
        dbuser: drupal8
        dbpass: test
        dbhost: localhost

  roles:
    - { role: common, tags: [common] }
    - { role: mysql , tags: [mysql] }

To run on a freshly installed ubuntu 16.04 you need to:

sudo apt install ansible
git clone https://github.com/axai-mx/ansible-drupal-roles.git
cd ansible-drupal-roles
sudo ansible-galaxy install -r provisioning/requirements.yml
wget this_file
ansible-playbook local.yml