Improve reporting with duplicate server-ids
作者: 絃樂之花 | 可以轉載, 但必須以超連結形式標明文章原始出處和作者資訊及版權宣告http://shiri512003.itpub.net/post/37713/499272[@more@]
測試xtrabackup搭建slave過程中,疏忽使用了其他slave的引數檔案,導致一個master下面掛了兩個server_id一樣的slave,結果自然是出現些意外。還好master沒有什麼影響,除了不斷的conn&disconn。。。,原本的slave自然也是錯誤不斷加不停的conn&disconn。。。,資料庫頻繁的login/out在繁忙事情是很危險的操作,特別是對於大量的conn&disonn,對於資料庫就是災難~
相關的一些資訊:
1.日誌裡面出現狂多的“Slave: received end packet from server, apparent master shutdown: ”這樣的資訊。由於這樣的提示資訊sec無法捕捉到,所以也一直沒有注意到。
67M alert.log
2.新的slave生成狂多的replay.*檔案,30w+,剛開始還以為是延時太久slave跟不上master導致的,結合後面發現的日誌資訊,應該是slave不斷中斷導致的。真是悲劇!
關於該問題已經有許多的bug report,可以參考下下面bug文件
Improve reporting with duplicate server-ids
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7591490/viewspace-1032921/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- to improve sqlite performanceSQLiteORM
- Error reporting for dbusError
- Oracle Reporting 6 - ModelOracle
- improve spring integration read message performance from mqSpringORMMQ
- Oracle Reporting 5 - WindowingOracle
- Oracle Reporting 7 - Model ExamplesOracle
- error_reporting()的用法Error
- duplicate databaseDatabase
- Oracle Reporting 2 - Subtotals and Grand TotalOracle
- Oracle Reporting 4 - Time Series CalculationsOracle
- RMAN duplicate databaseDatabase
- Oracle Reporting 3 - Aggregation LevelOracle
- 擴充套件部署(Reporting Services 配置)套件
- 遷移學習(IIMT)——《Improve Unsupervised Domain Adaptation with Mixup Training》遷移學習AIAPT
- PostgreSQL DBA(62) - PG 12 More progress reportingSQL
- Oracle Reporting 1 - Ratio_to_Report FunctionOracleFunction
- yum error - package is a duplicate withErrorPackage
- DUPLICATE DATABASE 注意事項Database
- 通過rman duplicate database!Database
- RMAN duplicate On Windows7Windows
- 程式碼匯出Reporting Services報表檔案
- Reporting Services 擴充套件裝置資訊設定套件
- rman duplicate操作手冊
- [LeetCode] Find the Duplicate NumberLeetCode
- Duplicate的一點總結
- Oracle DG搭建1(duplicate方式)Oracle
- Oracle 11G Duplicate DatabaseOracleDatabase
- RMAN duplicate database到新主機Database
- 使用duplicate克隆資料庫資料庫
- mysql INSERT ... ON DUPLICATE KEY UPDATEMySql
- 錯誤:duplicate column name: picstitle
- Reporting Services 安裝的備份和還原操作
- Oracle rman duplicate遷移測試Oracle
- LeetCode-Find the Duplicate NumberLeetCode
- MySQL_插入更新 ON DUPLICATE KEY UPDATEMySql
- LeetCode-Remove Duplicate LettersLeetCodeREM
- RMAN DUPLICATE建立DataGuard物理備庫
- rman duplicate搭建第二個 dg