#!/bin/bash

PATH=$PATH

logname=$(mysql --user=<%= mysql_replication_user %> --host=<%= mysql_master_ip_address %> --password=<%= mysql_replication_password %> --execute="show master status"  | grep mysqllog | awk '{ print $1 }')
export logname
position=$(mysql --user=<%= mysql_replication_user %> --host=<%= mysql_master_ip_address %> --password=<%= mysql_replication_password %> --execute="show master status"  | grep mysqllog | awk '{ print $2 }')
export position

rm /var/lib/mysql/set_master_repl_data.sql

export mysql_master_ip_address=<%= mysql_master_ip_address %>

#Build MySQL Master Data Script
#

echo CHANGE MASTER TO >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_HOST=\'$mysql_master_ip_address\', >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_USER=\'<%= mysql_replication_user %>\', >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_PASSWORD=\'<%= mysql_replication_password  %>\', >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_LOG_FILE=\'$logname\', >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_LOG_POS=$position, >> /var/lib/mysql/set_master_repl_data.sql
echo MASTER_CONNECT_RETRY=10\;  >> /var/lib/mysql/set_master_repl_data.sql

/usr/bin/mysql --user=<%= mysql_replication_user %> --password=<%= mysql_replication_password %>  --database=<%= mysql_root_database %> --host=<%= mysql_root_local_host %> --execute="source /var/lib/mysql/set_master_repl_data.sql"