- name: ensure partition exists
    parted:
      label: gpt
      device: /dev/sdb
      number: 1
      part_start: 2MB
      part_end: 800MB
      part_type: primary
- name: volume group exists
  lvg:
    vg: vg_database
    pvs: /dev/sdb1
    state: present
- name: logical volume exists
  lvol:
    vg: vg_database
    lv: lv_mysql
    size: 512MB
- name: filesystem exists
    filesystem:
      fstype: xfs
      dev: /dev/vg_database/lv_mysql
      state: present
- name:
    mount:
      src: /dev/vg_database/lv_mysql
      fstype: xfs
      mount_path: /mnt/mysql_backups
      state: mounted
- name: open firewall for mysql
    firewalld:
      port: 3306/tcp
      state: enabled
      permanent: yes
      immediate: yes
- name: start and enable mysql
    service:
      name: mysql

- name: change sql root passwd
    mysql_user:
      check_implicit_admin: yes
      login_user: root
      login_password: "{{ database_password }}"