| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- - 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 }}"
|
