summaryrefslogtreecommitdiffstats
path: root/roles/common-SQL
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2015-06-10 15:35:13 +0200
committerGuilhem Moulin <guilhem@fripost.org>2015-06-10 18:37:19 +0200
commitb408390ae9311b7d703ce57c25a78dce23c31b16 (patch)
treed9b1c795c0ef8b75dbaef709aa8622863d636942 /roles/common-SQL
parenta82e3759627a0612592d853796f2a1137f9189f5 (diff)
Configure munin nodes & master.
Interhost communications are protected by stunnel4. The graphs are only visible on the master itself, and content is generated by Fast CGI.
Diffstat (limited to 'roles/common-SQL')
-rw-r--r--roles/common-SQL/handlers/main.yml3
-rw-r--r--roles/common-SQL/tasks/main.yml35
2 files changed, 38 insertions, 0 deletions
diff --git a/roles/common-SQL/handlers/main.yml b/roles/common-SQL/handlers/main.yml
index 435c20e..d1d355f 100644
--- a/roles/common-SQL/handlers/main.yml
+++ b/roles/common-SQL/handlers/main.yml
@@ -1,3 +1,6 @@
---
- name: Restart MySQL
service: name=mysql state=restarted
+
+- name: Restart munin-node
+ service: name=munin-node state=restarted
diff --git a/roles/common-SQL/tasks/main.yml b/roles/common-SQL/tasks/main.yml
index b5c6773..9541be8 100644
--- a/roles/common-SQL/tasks/main.yml
+++ b/roles/common-SQL/tasks/main.yml
@@ -10,6 +10,8 @@
- mysql-common
- mysql-server
- python-mysqldb
+ # for the 'mysql_' munin plugin
+ - libcache-cache-perl
- name: Copy MySQL's configuration
copy: src=etc/mysql/my.cnf
@@ -43,3 +45,36 @@
- name: Start MySQL
service: name=mysql 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