Monitor Dual Master Mysql Replication


Here are shell script for monitoring replication, resetting replication if failed, logging if replication occured.
Write a file name mysqlslave.sh on /tmp directory.

#!/bin/sh

user=mysql_root_username
passwd=mysql_root_passwd

repuser=mysql_replica_username
reppasswd=mysql_replica_passwd

GO=1
while [ $GO=1 ]; do

rf=$(mktemp)

/usr/local/mysql/bin/mysql -u$user -p$passwd -e "show slave status \G" > $rf 2>&1

repl_IO=$(cat $rf|grep "Slave_IO_Running"|cut -f2 -d':')
repl_SQL=$(cat $rf|grep "Slave_SQL_Running"|cut -f2 -d':')

if [ "$repl_IO" != " Yes" -o "$repl_SQL" != " Yes" ] ; then
/usr/local/mysql/bin/mysql -u$user -p$passwd -e "stop slave"
/usr/local/mysql/bin/mysql -u$user -p$passwd -e "reset slave"

rg=$(mktemp)

/usr/local/mysql/bin/mysql -hserverb -u$repuser -p$reppasswd -e "show master status \G" > $rg 2>&1

filemaster=$(cat $rg|grep "File"|cut -f2 -d':'|cut -f2 -d' ')
positionmaster=$(cat $rg|grep "Position"|cut -f2 -d':')

/usr/local/mysql/bin/mysql -u$user -p$passwd -e "CHANGE MASTER TO MASTER_LOG_FILE='$filemaster', MASTER_LOG_POS=$positionmaster"

/usr/local/mysql/bin/mysql -u$user -p$passwd -e "start slave"

/bin/date >> /tmp/mysqlslave.log 2>&1

rm $rf $rg
fi
sleep 30
done

You can change duration of monitor by changing value of sleep.
You can check if any resetting slave log at /tmp/mysqlslave.log

Popular posts from this blog

Howto configure boot device order on ILOM

To ensure the system can be installed using the DVD drive, the boot device order in the BIOS has to be configured correctly so that the DVD drive takes precedence over the internal hard drives. 1 Log into the ILOM. 2 Start the system if it is not already running: > start /SYS else reset the system: > reset /SYS 3 Log onto the system’s console: > start /SP/console 4 When prompted, press Esc 2 to enter setup. 5 Once the setup menu has loaded, navigate across to the Boot screen by using the right arrow key. 6 Using the down arrow key, select the Boot Device Priority item and press Enter. 7 Confirm that the item [CD/DVD] is higher in the list than the item [Hard Drive]. The order can be changed by selecting the relevant item and using the +/- keys to move the item up or down in the list. 8 Once the order is correct, save any changes made by pressing Esc and then navigate right to the Exit screen. Select the item Save Changes and Exit and press Enter, then confirm...
Read more

Installing Depot files on HP-UX 11.23 ia64

Download your depot files from http://hpux.connect.org.uk/ based on your machine type. Download it, for example : bash-3.2-ia64-11.23.depot.gz, put it on /tmp. Install it with 2 option : 1. It will display SAM # swinstall -s /tmp/bash-3.2-ia64-11.23.depot.gz 2. It don't display SAM, so you get quick way # swinstall -s /tmp/bash-3.2-ia64-11.23.depot.gz bash Don't forget to install dependencies for this depot file, it's different from Redhat, who will reject rpm that missed dependencies. HP-UX accept all depots without any warning, but you must install dependencies yourself. You can know dependencies on http://hpux.connect.org.uk/, when you download, look at any dependencies for this depot file. Check depot files that already installed on your system # swlist Somehow any error happened when installing from directory another than /tmp, for example : /data. You should register that directory to depot. # cd /data # swreg -l depot `pwd` If it still fails, look at my post before a...
Read more

SAN Switch Config Command

Login via console Fabric OS (swd77) swd77 console login: admin Password: Note: password default is "password" - set hostname swd77:admin> switchName swcdr1 Committing configuration... Done. swcdr1:admin> - set IP Address swcdr1:admin> ipaddrset Ethernet IP Address [192.168.0.25]: 192.168.0.11 Ethernet Subnetmask [255.255.255.0]: Fibre Channel IP Address [0.0.0.0]: Fibre Channel Subnetmask [0.0.0.0]: Gateway IP Address [192.168.0.25]: 0.0.0.0 Issuing gratuitous ARP...Done. 2008/07/14-18:46:43, [WEBD-1007], 494,, INFO, swcdr1, HTTP server will be restarted due to change of IP Address IP address is being changed...Done. Committing configuration...Done. - Configure basic parameter swcdr1:admin> switchDisable swcdr1:admin> configure Configure... Fabric parameters (yes, y, no, n): [no] y Domain: (1..239) [1] 22008/07/14-18:50:40, [FW-1424], 24,, WARNING, swcdr1, Switch status changed from HEALTHY to MARGINAL. 2008/07/14-18:50:40, [FW-1439], 25,, WARNING, swcdr...
Read more