From dcca56c14c9c904237be46da0610179520dc8fde Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Sat, 10 Dec 2011 02:03:09 +0000 Subject: [PATCH] add autoslaveskip --- autoslaveskip | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100755 autoslaveskip diff --git a/autoslaveskip b/autoslaveskip new file mode 100755 index 0000000..be1ec87 --- /dev/null +++ b/autoslaveskip @@ -0,0 +1,12 @@ +#!/bin/bash + +while sleep 5s; do + echo -n $(date); + mysql -Be 'show slave status\G'|perl -ne 'm/(Seconds|Slave)_.+?\: (.+)\n/ && print " ".$2;'; + echo; + if ! mysql -Be 'show slave status\G'|awk '/Slave_SQL_Running/{print $2}'|grep -q Yes; then + echo "Advancing mysql by 1"; + mysql -Be "SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;"; + sleep 2s; + fi; +done; -- 2.39.5