é¦å
ï¼æ们大æ¦ç½åä¸ä¸ä¸»ä»å¤å¶çåºæ¬æ¥éª¤ï¼ï¼MySQL主ä»é¦å
éè¦å¨åèªæå¡å¨é
置好ï¼ã
1. å¤å¶æ°æ®åºã
mysqldump --master-data --single-transaction -R --databases [db_name] | gzip -9 - | pv > all-db-with-master-data.sql.gz
注æï¼innodbç¨ âsingle-transaction, myisaméè¦ç¨ âlock-all-tablesã
2. å¤å¶ï¼å¯¼å
¥æ°æ®ã
pv < all-db-with-master-data.sql.gz | zcat | mysql
3. å¯å¨slaveæ°æ®åºã
slave start
注æï¼åæ¢å°ä¸»çè¯å¥å·²ç»å¨å¯¼åºçsqlè¯å¥éé¢äºï¼æ³¨ææ¥çãchange master to master_log_file=â(binlog name in relay_master_log_file)â, master_log_pos=(exec_master_log_pos number)ã
é£ä¹ï¼å¨ç°æç主ä»å¤å¶ç»æä¸ï¼å¦ä½å¢å ä¸ä¸ªæ°çæ°æ®åºè¿å»ï¼æ¯å¦æ们è¦å¢å ä¸ä¸ªæ°æ®åºå¨masteræå¡å¨ä¸ï¼æ¯å¦ï¼å为newdbçæ°æ®åºã
å
·ä½æä½å¦ä¸ï¼
1. ä»æå¡ä¸ï¼åæslaveæ°æ®åºã
stop slave;
2. 主æå¡å¨ä¸ï¼å¯¼åºæ°æ°æ®åºã
mysqldump --master-data --single-transaction -R --databases newdb > newdb.sql
3. 主æå¡å¨ä¸ï¼ä¿®æ¹my.cnfæ件ï¼æ·»å æ°åºå°binlog-do-dbåæ°ï¼éå¯mysqlã
4. å¨å¯¼åºçnewdb.sqléé¢æ¥æ¾å½åçæ¥å¿æ件以åä½ç½®ï¼change master to â¦)
ç¶å让slaveæå¡å¨æ§è¡å°è¿ä¸ªä½ç½®ã
start slave until MASTER_LOG_FILE="mysql-bin.000001", MASTER_LOG_POS=1222220;
å
¶ä¸MASTER_LOG_FILE以åMASTER_LOG_POSå¨å¯¼åºçæ°æ®åºnewdb.sql顶é¨ä½ç½®æ¥æ¾ã
4. 导å
¥æ°åºå°ä»æå¡å¨ä¸ã
mysql < newdb.sql
5. start slave
å
¶ä¸æ¯è¾éè¦çæ¯å¨ä¸»æå¡å¨ä¸å¯¼åºæ°åºæ¶çæ¥å¿ä½ç½®ï¼position Aï¼ï¼è¿ä¸ªç¹å¾éè¦ï¼ä»¥è¿ä¸ªç¹å为åç线ï¼å¯¼å
¥æ°åºã
è¿ç§æ¹æ³ä¹åæ ·éç¨äºæ个æ°æ®åºæè
æ个æ°æ®è¡¨ä¸åæ¥çæ
åµï¼æ¯å¦ä¸»ä»æ°æ®åºæä¸ä¸ªè¡¨ç±äºæäºåå æ°æ®ä¸ä¸è´ï¼é£ä¹ä¸é¢çæ¹æ³åªéè¦å»æéå¯æ°æ®åºä¸æ¥ï¼å
¶ä»çæä½åºæ¬
温馨提示:答案为网友推荐,仅供参考