Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE USER repluser@'%' IDENTIFIED BY 'replpass';
- GRANT REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO repluser@'%';
- CHANGE MASTER TO
- master_host='10.20.30.40',
- master_port=3306,
- master_user='repluser',
- master_password='replpass',
- master_auto_position=1;
- CHANGE MASTER TO
- master_host='10.20.30.40',
- master_port=3306,
- master_user='repluser',
- master_password='replpass',
- master_log_file='mysql-bin.000001',
- master_log_pos=4;
- MYSQL_USER=root
- MYSQL_PASS=whatever
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- DB_TO_DUMP=mydb
- MYSQLDUMP_OPTIONS="--routines --triggers"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=1"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --single_transaction"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} -B ${DB_TO_DUMP}"
- date > live_dump_and_load.runlog
- mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} | mysql -h10.20.30.50 ${MYSQL_CONN}
- date >> live_dump_and_load.runlog
- chmod +x live_dump_and_load.sh
- nohup ./live_dump_and_load.sh &
- watch cat live_dump_and_load.runlog
- START SLAVE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement