X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/52fb5028cfb36bf1b9490aea22cde7127dbe00ce..e847b156af79e857466b8ca0f51d68ef69a6dd01:/cookbooks/mysql/recipes/default.rb?ds=sidebyside diff --git a/cookbooks/mysql/recipes/default.rb b/cookbooks/mysql/recipes/default.rb index 5cedc301f..aad3a7683 100644 --- a/cookbooks/mysql/recipes/default.rb +++ b/cookbooks/mysql/recipes/default.rb @@ -1,8 +1,8 @@ # -# Cookbook Name:: mysql +# Cookbook:: mysql # Recipe:: default # -# Copyright 2013, OpenStreetMap Foundation +# Copyright:: 2013, OpenStreetMap Foundation # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -17,6 +17,9 @@ # limitations under the License. # +include_recipe "munin" +include_recipe "prometheus" + package "mysql-server" package "mysql-client" @@ -29,10 +32,23 @@ template "/etc/mysql/mysql.conf.d/zzz-chef.cnf" do source "my.cnf.erb" owner "root" group "root" - mode 0o644 + mode "644" notifies :restart, "service[mysql]" end +service "apparmor" do + action :nothing +end + +template "/etc/apparmor.d/local/usr.sbin.mysqld" do + source "apparmor.erb" + owner "root" + group "root" + mode "644" + notifies :restart, "service[apparmor]" + only_if { ::Dir.exist?("/sys/kernel/security/apparmor") } +end + package "libdbd-mysql-perl" package "libcache-cache-perl" @@ -57,3 +73,16 @@ end action :delete end end + +mysql_password = persistent_token("mysql", "prometheus", "password") + +mysql_user "prometheus" do + password mysql_password + process true + repl_client true +end + +prometheus_exporter "mysqld" do + port 9104 + environment "DATA_SOURCE_NAME" => "prometheus:#{mysql_password}@(localhost:3306)/" +end