<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                >[info] 修復宕機的 master 和 日常維護命令 1. **修復宕機的 master:** 通常情況下自動切換以后,原master可能已經廢棄掉,待原master主機修復后,如果數據完整的情況下,可能想把原來master重新作為新主庫的slave,這時我們可以借助當時自動切換時刻的MHA日志來完成對原master的修復。下面是提取相關日志的命令: ``` # 查看日志內容 cat /var/log/mha/app1/manager.log All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='192.168.83.131', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000006', MASTER_LOG_POS=1769, MASTER_USER='slave', MASTER_PASSWORD='xxx'; ``` 意思是說,如果Master主機修復好了,可以在修復好后的Master執行 `change master` 操作,作為新的slave庫。 ***** 2. **日常維護命令:** ``` # SSH檢查 masterha_check_ssh --conf=/etc/mha/app1.cnf # 主從檢查 masterha_check_repl --conf=/etc/mha/app1.cnf # 停止MHA masterha_stop --conf=/etc/mha/app1.cnf # 檢查狀態 masterha_check_status --conf=/etc/mha /app1.cnf # 查看 master 日志 tail -f /var/log/mha/app1/manager.log # 當有slave 節點宕掉時,默認是啟動不了的,加上 --ignore_fail_on_start 即使有節點宕掉也能啟動MHA,如下: nohup masterha_manager --conf=/etc/masterha/app1.cnf --ignore_fail_on_start &>/tmp/mha_manager.log & ``` ***** 3. **示例:** 當前 master(192.168.83.130)已停止服務 3.1 登錄 master 啟動 mysql 服務 ``` service mysqld start ``` ![](https://img.kancloud.cn/98/f3/98f3f84310b6de30268aa8da3f7681c3_610x83.png) 3.2 根據 master 日志 manager.log 重新開始 `change master` ``` change master to master_host='192.168.83.131',master_user='slave',master_password='123456',master_log_file='mysql-bin.000006',master_log_pos=1769; start slave; show slave status \G; ``` ![](https://img.kancloud.cn/fe/7f/fe7f5a0a75bfc149d3b0503719c5ff21_1092x463.png) 3.3 再 新 master (192.168.83.131)插入數據查看效果 192.168.83.131:(主) ![](https://img.kancloud.cn/0f/c0/0fc0cc27c2510283e3228f7a5193e5f2_913x359.png) 192.168.83.132:(從1) ![](https://img.kancloud.cn/87/57/875733da6acf5d4b894d7fe042175c04_1016x583.png) 192.168.83.130:(從2,舊 master) ![](https://img.kancloud.cn/05/91/0591935460fc6731ccbd0ab9e1185adc_1009x602.png)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看