Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. CREATE USER repluser@'%' IDENTIFIED BY 'replpass';
  2. GRANT REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO repluser@'%';
  3.  
  4. CHANGE MASTER TO
  5. master_host='10.20.30.40',
  6. master_port=3306,
  7. master_user='repluser',
  8. master_password='replpass',
  9. master_auto_position=1;
  10.  
  11. CHANGE MASTER TO
  12. master_host='10.20.30.40',
  13. master_port=3306,
  14. master_user='repluser',
  15. master_password='replpass',
  16. master_log_file='mysql-bin.000001',
  17. master_log_pos=4;
  18.  
  19. MYSQL_USER=root
  20. MYSQL_PASS=whatever
  21. MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
  22. DB_TO_DUMP=mydb
  23. MYSQLDUMP_OPTIONS="--routines --triggers"
  24. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=1"
  25. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --single_transaction"
  26. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} -B ${DB_TO_DUMP}"
  27.  
  28. date > live_dump_and_load.runlog
  29. mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} | mysql -h10.20.30.50 ${MYSQL_CONN}
  30. date >> live_dump_and_load.runlog
  31.  
  32. chmod +x live_dump_and_load.sh
  33. nohup ./live_dump_and_load.sh &
  34.  
  35. watch cat live_dump_and_load.runlog
  36.  
  37. START SLAVE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement