《MYSQL數(shù)據(jù)庫mysql數(shù)據(jù)庫主從復(fù)制添加第N個(gè)從庫》要點(diǎn)：
本文介紹了MYSQL數(shù)據(jù)庫mysql數(shù)據(jù)庫主從復(fù)制添加第N個(gè)從庫，希望對您有用。如果有疑問，可以聯(lián)系我們。

#1 停止 mysql數(shù)據(jù)庫的從庫,鎖表,
???? 記住 Read_Master_Log_Pos: 與 Master_Log_File: (紅色字)
mysql> stop slave;
mysql> flush tables with read lock;
mysql> show slave statusG;
*************************** 1. row ***************************
?????????????? Slave_IO_State:
????????????????? Master_Host: 192.168.6.53
????????????????? Master_User: dongnan
????????????????? Master_Port: 3306
??????????????? Connect_Retry: 60
????????????? Master_Log_File: mysql-bin.000097
????????? Read_Master_Log_Pos: 19157395
?????????????? Relay_Log_File: zabbix-slave-relay-bin.000185
??????????????? Relay_Log_Pos: 11573578
??????? Relay_Master_Log_File: mysql-bin.000097
???????????? Slave_IO_Running: No
??????????? Slave_SQL_Running: No
????????????? Replicate_Do_DB:
????????? Replicate_Ignore_DB:
?????????? Replicate_Do_Table:
?????? Replicate_Ignore_Table:
????? Replicate_Wild_Do_Table:
? Replicate_Wild_Ignore_Table:
?????????????????? Last_Errno: 0
?????????????????? Last_Error:
???????????????? Skip_Counter: 0
????????? Exec_Master_Log_Pos: 19157395
????????????? Relay_Log_Space: 19142103
????????????? Until_Condition: None
?????????????? Until_Log_File:
??????????????? Until_Log_Pos: 0
?????????? Master_SSL_Allowed: No
?????????? Master_SSL_CA_File:
?????????? Master_SSL_CA_Path:
????????????? Master_SSL_Cert:
??????????? Master_SSL_Cipher:
?????????????? Master_SSL_Key:
??????? Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
??????????????? Last_IO_Errno: 0
??????????????? Last_IO_Error:
?????????????? Last_SQL_Errno: 0
?????????????? Last_SQL_Error:
1 row in set (0.00 sec)
?
ERROR:
No query specifiedMYSQL入門

#2 打包數(shù)據(jù)并發(fā)送到新從庫2服務(wù)器上
cd /usr/local/mysql/var/
tar czvf zabbix_20110805.tar.gz zabbix/
scp zabbix_20110805.tar.gz root@192.168.6.54:/rootMYSQL入門

《MYSQL數(shù)據(jù)庫mysql數(shù)據(jù)庫主從復(fù)制添加第N個(gè)從庫》是否對您有啟發(fā)，歡迎查看更多與《MYSQL數(shù)據(jù)庫mysql數(shù)據(jù)庫主從復(fù)制添加第N個(gè)從庫》相關(guān)教程，學(xué)精學(xué)透。維易PHP學(xué)院為您提供精彩教程。

轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/14313.html