majic-ansible-roles Files · roles/database

Files @ 09625826d96f

Branch filter:

Location: majic-ansible-roles/roles/database_server/tasks/main.yml

09625826d96f 696 B text/x-yaml Show Annotation Show as Raw Download as Raw

branko

MAR-15: Added implementation for the database server role. Performs very simpled deployment and set-up of MariaDB database server.

---

- name: Install MariaDB
  apt: name="{{ item }}" state=installed
  with_items:
    - mariadb-client
    - mariadb-server
    - python-mysqldb

- name: Enable and start MariaDB
  service: name=mysql enabled=yes state=started

- name: Set password for the root database user
  mysql_user: check_implicit_admin=yes name=root password="{{ db_root_password }}"

- name: Deploy username and password for the root database user
  template: src="root_my.cnf.j2" dest="/root/.my.cnf"
            owner=root group=root mode=400

- name: Set UTF-8 encoding as default for MariaDB
  copy: src="utf8.cnf" dest="/etc/mysql/conf.d/utf8.cnf"
        owner=root group=root mode=644
  notify: Restart MariaDB