[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
MySQL replication status checker
- To: hobbit (at) hswn.dk
- Subject: MySQL replication status checker
- From: Charles Jones <jonescr (at) cisco.com>
- Date: Mon, 24 Sep 2007 16:26:43 -0700
- Authentication-results: rtp-dkim-1; header.From=jonescr (at) cisco.com; dkim=pass ( sig from cisco.com/rtpdkim1001 verified; );
- Dkim-signature: v=0.5; a=rsa-sha256; q=dns/txt; l=531; t=1190676543; x=1191540543; c=relaxed/simple; s=rtpdkim1001; h=Content-Type:From:Subject:Content-Transfer-Encoding:MIME-Version; d=cisco.com; i=jonescr (at) cisco.com; z=From:=20Charles=20Jones=20<jonescr (at) cisco.com> |Subject:=20MySQL=20replication=20status=20checker |Sender:=20 |To:=20hobbit (at) hswn.dk; bh=p+CZpoHdFXyD2pYkHtMeDKWbdxBPXNX5EhpGV5ggqAQ=; b=PpirjQJleSfVtFsr46c8OglCFyZe8azW9lY0xo5Z1twXKyYhWxRE/9+up93K/ByqyXaD2Ufj yZoDOQaYU/gPFW71MM7RLlD5DZkGk2ZVAanf+IlvPziZY+Upvsd910Xq;
- User-agent: Thunderbird 2.0.0.5 (X11/20070719)
I just got bit hard by a MySQL replication error, so I'm about to write
a Hobbit client-side ext script that will check the local servers slave
status (CHECK SLAVE STATUS \G), parse the output, and alert
appropriately (red if Slave Running = No, or if Seconds Behind Master
>300, yellow if Seconds Behind Master <300 but > 60...otherwise green).
If anyone already has a script that does this, please let me know, and
let's put it on The Shire. If nobody else has one, I will whip one up
and share it.
-Charles