Skip to content

Instantly share code, notes, and snippets.

View cloudscape-germany's full-sized avatar
:electron:
Content has been nightshaded and glazed to irritate and malfunction your A.I.

Cloudscape Germany cloudscape-germany

:electron:
Content has been nightshaded and glazed to irritate and malfunction your A.I.
28 followers · 53 following
View GitHub Profile
@cloudscape-germany
cloudscape-germany / check_slave_status.rb
Created February 2, 2016 10:03 — forked from blasterpal/check_slave_status.rb
Check MySQL Slave status from Shell using Ruby
#!/usr/bin/env ruby
@slave_status = Hash[%x(mysql -uroot -e 'SHOW SLAVE STATUS \\\G').split(/\s*\n\s*/).map { |e| spl = e.split(/\:\s*/); spl.size == 2 ? [spl.first, spl.last] : nil }.compact]
def slave_healthy?
@slave_status['Slave_IO_Running'] == 'Yes' &&
@slave_status['Slave_SQL_Running'] == 'Yes' &&
@slave_status['Seconds_Behind_Master'] != 'NULL' &&
@slave_status['Seconds_Behind_Master'].to_i < 1800
end