Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pc 1
- master
- grant replication slave on *.* to 'replicator'@'%'identified by 'replicator';
- flush privilege;
- flush tables with read lock;
- show master status;
- unlock tables;
- pc 2
- master
- grant replication slave on *.* to 'replicator2'@'%'identified by 'replicator2';
- flush privileges;
- flush tables with read lock;
- show master status;
- unlock tables;
- pc 3
- master
- grant replication slave on *.* to 'replicator3'@'%'identified by 'replicator3';
- flush privilages;
- flush tables with read lock;
- show master status;
- unlock tables;
- pc1
- slave
- change master to master_host='IPmaster',
- master_user='replicator2',
- master_password='replicator2',
- master_log_file='mysql-bin.lihat di master',
- master_log_pos=lihat di master ;
- pc1
- slave
- change master to master_host='IPmaster',
- master_user='replicator3',
- master_password='replicator3',
- master_log_file='mysql-bin.lihat di master',
- master_log_pos=lihat di master ;
- pc2
- slave
- change master to master_host='192.168.45.23',
- master_user='replicator',
- master_password='replicator',
- master_log_file='mysql-bin.000002',
- master_log_pos=925;
- pc2
- slave
- change master to master_host='IPmaster',
- master_user='replicator3',
- master_password='replicator3',
- master_log_file='mysql-bin.lihat di master',
- master_log_pos=lihat di master ;
- pc3
- slave
- change master to master_host='IPmaster',
- master_user='replicator',
- master_password='replicator',
- master_log_file='mysql-bin.lihat di master',
- master_log_pos=lihat di master ;
- pc3
- slave
- change master to master_host='IPmaster',
- master_user='replicator2',
- master_password='replicator2',
- master_log_file='mysql-bin.lihat di master',
- master_log_pos=lihat di master ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement