Advertisement
Guest User

Untitled

a guest
Nov 11th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. MYSQL_MAS=10.20.30.40
  2. MYSQL_SLV=10.20.30.50
  3. MYSQL_USER=root
  4. MYSQL_PASS=rootpassword
  5. MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
  6. MYSQL_CONN_MAS="-h${MYSQL_MAS} -u${MYSQL_CONN}"
  7. MYSQL_CONN_SLV="-h${MYSQL_SLV} -u${MYSQL_CONN}"
  8. REPL_USER=replicator
  9. REPL_PASS=whateverthereplicatorpasswordis
  10. DATABASE_TO_DUMP=mydb
  11. MYSQLDUMP_OPTIONS="--single-transaction"
  12. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=1"
  13. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --routines --triggers"
  14. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --add-drop-database"
  15. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} -B ${DATABASE_TO_DUMP}"
  16.  
  17. SQL="STOP SLAVE;"
  18. SQL="${SQL} CHANGE MASTER TO master_host='${MYSQL_MAS},master_port=3306,"
  19. SQL="${SQL} master_user='${REPL_USER},master_password='${REPL_PASS}',"
  20. SQL="${SQL} master_log_file='blank',master_log_pos=4;"
  21.  
  22. mysql ${MYSQL_CONN_SLV} -ANe"${SQL}"
  23. mysqldump ${MYSQL_CONN_MAS} ${MYSQLDUMP_OPTIONS} | mysql ${MYSQL_CONN_SLV}
  24. mysql ${MYSQL_CONN_SLV} -ANe"START SLAVE;"
  25.  
  26. chmod +x LoadSlave.sh
  27. nohup ./LoadSlave.sh &
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement