欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

【MySQL】Server-id導(dǎo)致Slave_IO_Running:No主從復(fù)制故障

【問(wèn)題描述】：
在master停機(jī)維護(hù)啟動(dòng)服務(wù)之后，slave的Slave_IO_Running狀態(tài)被置為NO
Slave_SQL_Running為Yes，猜測(cè)應(yīng)該是master的鍋
繼續(xù)檢查網(wǎng)絡(luò)，權(quán)限等問(wèn)題之后仍然為不可用
也嘗試重新
change master to ...., ...., ....,
master_log_file = 'master-bin.034555',
master_log_pos = 98;
依舊不可用

  1. 160322 9:42:51 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.034555' at position 98, relay log './MySQLd-relay-bin.0000
  2. 01' position: 4
  3. 160322 9:43:01 [Note] Slave I/O thread: connected to master 'repl@*.*.*.*:3306', replication started in log 'master-bin.034555' at position 98
  4. 160322 9:43:01 [ERROR] Error reading packet from server: Misconfigured master -server id was not set ( server_errno=1236)
  5. 160322 9:43:01 [ERROR] Got fatal error 1236: 'Misconfigured master - server id was not set' from master when reading data from binary log
  6. 160322 9:43:01 [Note] Slave I/O thread exiting, read up to log 'master-bin.034555', position 98
  7. 160322 9:43:07 [Note] Error reading relay log event: slave SQL thread was killed

檢查配置文件發(fā)現(xiàn)#server-id = xxx 被注釋

【解決方案】：
由于server_id為“Dynamic Variable”
故到master中手動(dòng)執(zhí)行
  1. mysql> SET GLOBAL server_id=3028;
  2. Query OK, 0 rows affected(0.00 sec)

最后在將配置文件中添加
server-id=3028

在slave上檢查：
  1. mysql> SHOWSLAVE STATUS\G
  2. *************************** 1. row***************************
  3.              Slave_IO_State: Waitingfor masterto send event
  4.                 Master_Host: 192.168.30.28
  5.                 Master_User: repl
  6.                 Master_Port: 3306
  7.               Connect_Retry: 60
  8.             Master_Log_File:master-bin.034556
  9.         Read_Master_Log_Pos: 59312658
  10.              Relay_Log_File: mysqld-relay-bin.000002
  11.               Relay_Log_Pos: 64698308
  12.       Relay_Master_Log_File:master-bin.034555
  13.            Slave_IO_Running: Yes
  14.           Slave_SQL_Running: Yes
  15.                       …………………………
  16.       Seconds_Behind_Master: 10071
  17. 1 rowin set (0.00 sec)

解決。


同樣，某些時(shí)候在start slave時(shí)報(bào)錯(cuò)“The server is not configured as slave”，
同樣也很有可能是server-id的緣故，只需要手動(dòng)在主和從庫(kù)上執(zhí)行：
SET GLOBAL server_id = xxx，并保證兩臺(tái)server-id不一樣即可，最后寫(xiě)入my.cnf中。


作者微信公眾號(hào)（持續(xù)更新）
【MySQL】Server-id導(dǎo)致Slave_IO_Running: No主從復(fù)制故障

網(wǎng)頁(yè)題目：【MySQL】Server-id導(dǎo)致Slave_IO_Running:No主從復(fù)制故障
文章分享：http://www.chinadenli.net/article0/jsgdio.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計(jì)公司、網(wǎng)站改版、做網(wǎng)站、App設(shè)計(jì)、外貿(mào)建站、品牌網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)

網(wǎng)站建設(shè)網(wǎng)站維護(hù)公司