Advertisement
Guest User

Untitled

a guest
Dec 20th, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. pc 1
  2. master
  3. grant replication slave on *.* to 'replicator'@'%'identified by 'replicator';
  4. flush privilege;
  5. flush tables with read lock;
  6. show master status;
  7. unlock tables;
  8.  
  9. pc 2
  10. master
  11. grant replication slave on *.* to 'replicator2'@'%'identified by 'replicator2';
  12. flush privileges;
  13. flush tables with read lock;
  14. show master status;
  15. unlock tables;
  16.  
  17. pc 3
  18. master
  19. grant replication slave on *.* to 'replicator3'@'%'identified by 'replicator3';
  20. flush privilages;
  21. flush tables with read lock;
  22. show master status;
  23. unlock tables;
  24.  
  25. pc1
  26. slave
  27. change master to master_host='IPmaster',
  28. master_user='replicator2',
  29. master_password='replicator2',
  30. master_log_file='mysql-bin.lihat di master',
  31. master_log_pos=lihat di master ;
  32.  
  33. pc1
  34. slave
  35. change master to master_host='IPmaster',
  36. master_user='replicator3',
  37. master_password='replicator3',
  38. master_log_file='mysql-bin.lihat di master',
  39. master_log_pos=lihat di master ;
  40.  
  41. pc2
  42. slave
  43. change master to master_host='192.168.45.23',
  44. master_user='replicator',
  45. master_password='replicator',
  46. master_log_file='mysql-bin.000002',
  47. master_log_pos=925;
  48.  
  49. pc2
  50. slave
  51. change master to master_host='IPmaster',
  52. master_user='replicator3',
  53. master_password='replicator3',
  54. master_log_file='mysql-bin.lihat di master',
  55. master_log_pos=lihat di master ;
  56.  
  57. pc3
  58. slave
  59. change master to master_host='IPmaster',
  60. master_user='replicator',
  61. master_password='replicator',
  62. master_log_file='mysql-bin.lihat di master',
  63. master_log_pos=lihat di master ;
  64.  
  65. pc3
  66. slave
  67. change master to master_host='IPmaster',
  68. master_user='replicator2',
  69. master_password='replicator2',
  70. master_log_file='mysql-bin.lihat di master',
  71. master_log_pos=lihat di master ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement