Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW MASTER STATUS;
- mysql> show master status;
- +------------------+----------+--------------+------------------+-------------------+
- | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
- +------------------+----------+--------------+------------------+-------------------+
- | mysql-bin.000266 | 120 | | | |
- +------------------+----------+--------------+------------------+-------------------+
- 1 row in set (0.00 sec)
- [mysqld]
- log-bin=mysql-bin
- GRANT REPLICATION CLIENT,REPLICATION SLAVE ON *.*
- TO replicator@'%' IDENTIFIED BY 'replicationpass';
- MASTER_IP=10.20.30.100
- mysql -h${MASTER_IP} -ureplicator -preplicationpass -ANe"SHOW VARIABLES LIKE 'hostname'"
- mysql> RESET MASTER;
- MASTER_IP=10.20.30.100
- echo "CHANGE MASTER TO master_host='${MASTER_IP}'," > LoadSlaveData.sql
- echo "master_post=3306,master_user='replicator'," >> LoadSlaveData.sql
- echo "master_password='replicationpass'," >> LoadSlaveData.sql
- echo "master_log_file='bogus'," >> LoadSlaveData.sql
- echo "master_log_pos=2;" >> LoadSlaveData.sql
- DUMP_OPTIONS="-single-transaction --master_data=1 --routines --triggers"
- mysqldump --uroot -p ${DUMP_OPTIONS} --all-databases >> LoadSlaveData.sql
- echo "START SLAVE;" >> LoadSlaveData.sql
- mysql -h10.20.30.110 -uroot -p < LoadSlaveData.sql
- mysql -h10.20.30.120 -uroot -p < LoadSlaveData.sql
- mysql -h10.20.30.130 -uroot -p < LoadSlaveData.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement