Advertisement
Guest User

Untitled

a guest
May 25th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. New data at MASTER gets saved to SLAVE as backup data
  2.  
  3. MASTER > 192.168.1.5
  4. SLAVE > 192.168.1.8
  5. ### TEST CONNECTION on BOTH SIDES with $nc IP 3306
  6. # MASTER config
  7. $vi /etc/mysql/my.cnf
  8. * add
  9. bind-address = LOCAL_IP_ADDRESS
  10. server-id=1
  11. log_bin=/var/log/mysql-master-bin
  12. log_error=/var/log/mysql-master-bin.err
  13. binlog_do_db=tours
  14.  
  15. *run
  16. $service mysql restart
  17. GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'bob';
  18. FLUSH PRIVILEGES;
  19. USE replicationDB;
  20. FLUSH TABLES WITH READ LOCK;
  21. SHOW MASTER STATUS; #### GET File & Position values
  22. $mysqldump -u root -p --opt replicationDB > replicationDB.sql ### EXPORT
  23. UNLOCK TABLES;
  24. QUIT;
  25.  
  26. # SLAVE config
  27. CREATE DATABASE replicationDB;
  28. EXIT;
  29. $mysql -u root -p replicationDB < replicationDB.sql ### IMPORT
  30.  
  31. $vi /etc/mysql/my.cnf
  32. * add
  33. server-id = 2
  34. relay-log = /var/log/mysql/mysql-relay-bin.log
  35. log_bin = /var/log/mysql/mysql-bin.log
  36. binlog_do_db = replicationDB
  37.  
  38. $service mysql restart
  39. CHANGE MASTER TO MASTER_HOST='MASTER_IP_ADDRESS',
  40. MASTER_USER='slave_user',
  41. MASTER_PASSWORD='bob',
  42. MASTER_LOG_FILE='mysql-bin.000001', ### GOT FROM File value
  43. MASTER_LOG_POS= 107; ### GOT FROM Position value
  44. START SLAVE;
  45. SHOW SLAVE STATUS;
  46. ### IF ERROR: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; SLAVE START;
  47.  
  48. *** DONE ***
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement