dbservers.yml

---
- hosts: localhost
  connection: local
  gather_facts: no
  environment:
    AWS_ACCESS_KEY_ID: "{{ aws_access_key_id }}"
    AWS_SECRET_ACCESS_KEY: "{{ aws_secret_access_key }}"
    AWS_REGION: "{{ AWS_REGION  }}"
  vars_files:
    - keys
  tasks:
    - name: Get VPC information
      include_role: 
        name: vpc
      vars:
        fetch_vpc_info: True
      when: hostvars['localhost']['create_initial_vpc'] is not defined

- hosts: database
  become: true
  vars_files:
    - keys
  vars:
    ansible_ssh_common_args: "-o ProxyCommand='ssh -o StrictHostKeyChecking=no -i {{ private_key_location }} -W %h:%p -q ubuntu@{{ hostvars['localhost']['bastion_ip'] }}'"
  tasks:
    - name: Patch database hosts
      include_role:
        name: patching
      when: hostvars['localhost']['create_initial_vpc'] is defined
    - name: Install common packages
      include_role:
        name: common
      when: hostvars['localhost']['create_initial_vpc'] is defined
    - name: Configure database servers
      include_role:
        name: mysql
      vars:
        configure_database_host: True
      when: hostvars['localhost']['create_initial_vpc'] is defined

- hosts: database
  become: true
  environment:
    AWS_ACCESS_KEY_ID: "{{ aws_access_key_id }}"
    AWS_SECRET_ACCESS_KEY: "{{ aws_secret_access_key }}"
    AWS_REGION: "{{ AWS_REGION  }}"
  vars_files:
    - keys
  tasks:
    - name: Make sure common packages are installed
      include_role:
        name: common
    - name: Configure database
      include_role:
        name: mysql
      vars:
        configure_database_host: True
      when: hostvars['localhost']['create_initial_vpc'] is not defined