Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL_USER=root
- MYSQL_PASS=password
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- SQL="SELECT schema_name FROM information_schema.schemata"
- SQL="${SQL} WHERE schema_name NOT IN "
- SQL="${SQL} ('information_schema','performance_schema','mysql','test','sys')"
- DBLIST=`mysql ${MYSQL_CONN} -ANe"${SQL} 2>/dev/null"`
- MYSQLDUMP_OPTIONS="--single-transaction --routines --triggers --master-data=2"
- mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} -B ${DBLIST} | gzip > DataFromServerA.sql.gz
- MYSQL_USER=root
- MYSQL_PASS=password
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- SQL="SELECT schema_name FROM information_schema.schemata"
- SQL="${SQL} WHERE schema_name NOT IN "
- SQL="${SQL} ('information_schema','performance_schema','mysql','test','sys')"
- DBLIST=`mysql ${MYSQL_CONN} -ANe"${SQL} 2>/dev/null"`
- MYSQLDUMP_OPTIONS="--single-transaction --routines --triggers --dump-slave=2"
- mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} -B ${DBLIST} | gzip > DataFromServerA.sql.gz
- less DataFromServerA.sql.gz | head -23 | tail -2
- -- CHANGE MASTER TO MASTER_LOG_FILE='bin-log.001236', MASTER_LOG_POS=102938;
- MYSQL_USER=root
- MYSQL_PASS=password
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- gzip -d < DataFromServerA.sql.gz | mysql ${MYSQL_CONN}
- GRANT REPLICATION SLAVE,REPLICATION CLIENT
- ON *.* TO 'cutover'@'%'
- IDENTIFIED BY 'cutover';
- CHANGE MASTER TO
- master_host='10.20.30.40',
- master_port=3306,
- master_user='cutover',
- master_password='cutover',
- master_log_file='bin-log.001236',
- master_log_pos=102938;
- START SLAVE;
- SLAVE SLAVE STATUSG
- SET GLOBAL read_only = 1;
- FLUSH TABLES;
- FLUSH LOGS;
- STOP SLAVE;
- RESET SLAVE ALL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement