database-cache.yml

- hosts: database
  become: yes
  tasks: 
  - name: Garantindo Pacotes
    package:
      name: ['mariadb', 'memcached', 'python3-PyMySQL']
      state: present
  - name: Garantindo MariaDB e Memcached em interface privada
    lineinfile:
      path: '{{ item.path }}'
      line:  '{{ item.line }}'
      regex:  '{{ item.regex }}'
    loop:
    - path: /etc/sysconfig/memcached
      line: OPTIONS="-l 172.27.11.30"
      regex: OPTIONS="-l
    - path: /etc/my.cnf.d/mariadb-server.cnf
      line: bind-address=172.27.11.30
      regex: '#?bind-address\s*=\s*[\d]{1,3}\.[\d]{1,3}\.[\d]{1,3}\.[\d]{1,3}'
  - name: Garantindo servicos MariaDB e Memcached
    service: #systemd
      name: '{{ item }}'
      state: started # stopped, restarted, reloaded
      enabled: yes
    loop:
    - mariadb
    - memcached
  - name: Copiando base de dados
    copy:
      src: /root/playbooks/files/dump.sql
      dest: /tmp/dump.sql
  - name: Garantindo base de dados da aplicacao
    community.mysql.mysql_db:
      name: infraagil
      login_unix_socket: /var/lib/mysql/mysql.sock
    register: database
  - name: Garantindo dados iniciais
    community.mysql.mysql_db:
      name: infraagil
      login_unix_socket: /var/lib/mysql/mysql.sock
      state: import
      target: /tmp/dump.sql
    when: database.changed
  - name: Garantindo usuario da aplicacao
    community.mysql.mysql_user:
      name: devops
      password: 4linux
      priv: infraagil.*:ALL
      host: '%'
      login_unix_socket: /var/lib/mysql/mysql.sock