add some postgres checks

rubygems · Aug 7, 2014 · b5cf4d2 · b5cf4d2
1 parent b5df487
commit b5cf4d2
Show file tree

Hide file tree

Showing 6 changed files with 10,604 additions and 3 deletions.
diff --git a/Berksfile.lock b/Berksfile.lock
@@ -286,7 +286,7 @@ GRAPH
     nginx (>= 0.0.0)
     rubygems (>= 0.0.0)
   rubygems-ruby (0.0.1)
-  rubygems-sensu (0.0.72)
+  rubygems-sensu (0.0.73)
     chef-vault (>= 0.0.0)
     sensu (>= 0.0.0)
   rubygems-ssh (0.0.4)

diff --git a/cookbooks/rubygems-sensu/files/default/check_postgres.pl b/cookbooks/rubygems-sensu/files/default/check_postgres.pl
diff --git a/cookbooks/rubygems-sensu/metadata.rb b/cookbooks/rubygems-sensu/metadata.rb
@@ -1,7 +1,7 @@
 name 'rubygems-sensu'
 maintainer 'RubyGems.org ops team'
 
-version '0.0.72'
+version '0.0.73'
 
 depends 'chef-vault'
 depends 'sensu'

diff --git a/cookbooks/rubygems-sensu/recipes/base.rb b/cookbooks/rubygems-sensu/recipes/base.rb
@@ -9,7 +9,7 @@
 
 package 'nagios-plugins'
 
-%w( check-procs.rb ).each do |plugin|
+%w( check-procs.rb check_postgres.pl ).each do |plugin|
   cookbook_file "/etc/sensu/plugins/#{plugin}" do
     source plugin
     path "/etc/sensu/plugins/#{plugin}"

diff --git a/cookbooks/rubygems-sensu/recipes/database.rb b/cookbooks/rubygems-sensu/recipes/database.rb
@@ -0,0 +1,28 @@
+#
+# Cookbook Name:: rubygems-sensu
+# Recipe:: database
+#
+
+sensu_check 'check_postgres_proc' do
+  command "/opt/sensu/embedded/bin/ruby /etc/sensu/plugins/check-procs.rb -p 'postgres -D'"
+  handlers ['slack', 'pagerduty']
+  subscribers ['database']
+  interval 30
+  additional(notification: 'postgres is not running', occurences: 3)
+end
+
+sensu_check 'check_postgres_connection' do
+  command "perl check_postgres.pl --action connection -db rubygems_#{node.chef_environment}"
+  handlers ['slack', 'pagerduty']
+  subscribers ['database']
+  interval 30
+  additional(occurences: 3)
+end
+
+sensu_check 'check_postgres_backends' do
+  command "perl check_postgres.pl --action backends -db rubygems_#{node.chef_environment}"
+  handlers ['slack', 'pagerduty']
+  subscribers ['database']
+  interval 30
+  additional(occurences: 3)
+end
diff --git a/cookbooks/rubygems-sensu/recipes/default.rb b/cookbooks/rubygems-sensu/recipes/default.rb
@@ -32,4 +32,5 @@
 include_recipe 'rubygems-sensu::balancer'
 include_recipe 'rubygems-sensu::app'
 include_recipe 'rubygems-sensu::nginx'
+include_recipe 'rubygems-sensu::database'
 include_recipe 'sensu::client_service'