Sensu check plugin for MariaDB / MySQL Replication Manager

check-replication-manager.rb

#!/usr/bin/env ruby
# check-replication-manager.rb
# Copyright 2017 SIGNAL 18 <support@signal18.io>
# Released under the MIT License. Full text at https://opensource.org/licenses/MIT

require 'sensu-plugin/check/cli'
require 'json'
require 'net/http'

class MRMCheck < Sensu::Plugin::Check::CLI

  check_name 'mrm_check'

  def run
    uri = URI('http://localhost:10001/servers')
    res = Net::HTTP.get_response(uri)

    srv_hash = JSON.parse(res.body)

    srv_stdl = 0
    srv_fail = 0
    srv_mstr = 0
    srv_repl = 0

    srv_hash.each do |array|
      if array['State'] == 'Standalone'
        srv_stdl += 1
      elsif array['State'] == 'Failed'
        srv_fail += 1
      elsif array['State'] == 'Master'
        srv_mstr += 1
      elsif array['State'] == 'Slave'
        srv_repl += 1
      end
    end

    if srv_fail > 0
      critical "Servers in failed status: #{srv_fail}"
    elsif srv_stdl > 0
      warning "Servers not connected: #{srv_stdl}"
    else
      ok "#{srv_mstr} master and #{srv_repl} replica servers monitored"
    end

  end
end