Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL_MAS=10.20.30.40
- MYSQL_SLV=10.20.30.50
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- MYSQL_CONN_MAS="-h${MYSQL_MAS} -u${MYSQL_CONN}"
- MYSQL_CONN_SLV="-h${MYSQL_SLV} -u${MYSQL_CONN}"
- REPL_USER=replicator
- REPL_PASS=whateverthereplicatorpasswordis
- DATABASE_TO_DUMP=mydb
- MYSQLDUMP_OPTIONS="--single-transaction"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=1"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --routines --triggers"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --add-drop-database"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} -B ${DATABASE_TO_DUMP}"
- SQL="STOP SLAVE;"
- SQL="${SQL} CHANGE MASTER TO master_host='${MYSQL_MAS},master_port=3306,"
- SQL="${SQL} master_user='${REPL_USER},master_password='${REPL_PASS}',"
- SQL="${SQL} master_log_file='blank',master_log_pos=4;"
- mysql ${MYSQL_CONN_SLV} -ANe"${SQL}"
- mysqldump ${MYSQL_CONN_MAS} ${MYSQLDUMP_OPTIONS} | mysql ${MYSQL_CONN_SLV}
- mysql ${MYSQL_CONN_SLV} -ANe"START SLAVE;"
- chmod +x LoadSlave.sh
- nohup ./LoadSlave.sh &
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement