mysos/executor/files/bin/mysql/scripts/mysos_log_position.sh

#!/bin/sh
#
# Get the log position of the MySQL slave.
#

set -uxe

slave_host=$1
slave_port=$2

# Get the relay log file.
relay_master_log_file=`mysql -u root -P $slave_port -h $slave_host -e "show slave status\G;" | \
  grep Relay_Master_Log_File | awk '{print $2}'`

# Get the relay log position.
exec_master_log_pos=`mysql -u root -P $slave_port -h $slave_host -e "show slave status\G;"  | \
  grep Exec_Master_Log_Pos | awk '{print $2}'`

# The output can be empty if the slave has not set up replication.
echo $relay_master_log_file,$exec_master_log_pos