#!/bin/bash ## PATH export PATH=$PATH:/usr/local/mysql/bin failuretype=`cat /usr/local/orchestrator/log/detected_failuretype.log` if [ "$failuretype" = "DeadMaster" ] then ## Failure Master Host IP failed_host_ip=`mysql --login-path=orchuser -sN -e "select ipv4 from orchestrator.hostname_ips where hostname='$1'"` failed_host_db_port=`mysql --login-path=orchuser -sN -e "select port from orchestrator.database_instance where hostname='$1'"` topologyuser=`grep -i MySQLTopologyUser /usr/local/orchestrator/orchestrator.conf.json | awk '{print $2}' | sed "s/,//g" | sed "s/\"//g"` topologypassword=`grep -i MySQLTopologyPassword /usr/local/orchestrator/orchestrator.conf.json | awk '{print $2}' | sed "s/,//g" | sed "s/\"//g"` db_version=`mysql --login-path=orchuser -sN -e "select substr(version,1,1) from orchestrator.database_instance where hostname='$1'"` if [ "$db_version" = "5" ] then mysql -u$topologyuser -p$topologypassword -h $failed_host_ip -P $failed_host_db_port -sN -e "start slave" else mysql -u$topologyuser -p$topologypassword -h $failed_host_ip -P $failed_host_db_port -sN -e "start replica" fi fi echo "Graceful Takeover Replica Start"