summaryrefslogtreecommitdiffstats
path: root/roles/common-SQL/tasks/main.yml
blob: 927f567d6ded29009cb2f9e2059892a2a8ce8292 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
- name: Install MariaDB
  apt: pkg={{ packages }}
  vars:
    packages:
    - mariadb-common
    - mariadb-server
    - python-mysqldb
    # for the 'mysql_' munin plugin
    - libcache-cache-perl

- name: Copy MySQL/MariaDB configuration
  copy: src=etc/mysql/mariadb.conf.d/99-user.cnf
        dest=/etc/mysql/mariadb.conf.d/99-user.cnf
        owner=root group=root
        mode=0644
  register: r
  notify:
    - Restart MariaDB

# We need to restart now and load the relevant authplugin before we
# connect to the database.
- meta: flush_handlers

# XXX Dirty fix for #742046
- name: Force root to use UNIX permissions
  mysql_user2: name=root password="" auth_plugin=unix_socket soname=auth_socket.so
               state=present

- name: Disallow anonymous and TCP/IP root login
  mysql_user2: name={{ item.name|default('') }} host={{ item.host }}
               state=absent
  with_items:
    - {             host: '{{ inventory_hostname_short }}' }
    - {             host: 'localhost' }
    - {             host: '127.0.0.1'}
    - {             host: '::1'}
    - { name: root, host: '{{ inventory_hostname_short }}' }
    - { name: root, host: '127.0.0.1'}
    - { name: root, host: '::1'}

- name: Start MariaDB
  service: name=mariadb state=started


- name: Install 'mysql_' Munin wildcard plugin
  file: src=/usr/share/munin/plugins/mysql_
        dest=/etc/munin/plugins/mysql_{{ item }}
        owner=root group=root
        state=link force=yes
  with_items:
    # sudo /usr/share/munin/plugins/mysql_ suggest
    - bin_relay_log
    - commands
    - connections
    - files_tables
    - innodb_bpool
    - innodb_bpool_act
    - innodb_io
    - innodb_log
    - innodb_rows
    - innodb_semaphores
    - innodb_tnx
    - myisam_indexes
    - qcache
    - qcache_mem
    - select_types
    - slow
    - sorts
    - table_locks
    - tmp_tables
  tags:
    - munin
    - munin-node
  notify:
    - Restart munin-node