<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>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## **一主一從搭建:** **環境:** | 主機 | 系統版本 | | --- | --- | | db01 | 192.168.230.101 | | db02 | 192.168.230.102 | ***** **前提條件:** 1. 字符集 show variables like '%char%'; [mysqld] character_set_server=utf8 2. 開啟 binlog show variables like '%log_bin%'; ![](https://img.kancloud.cn/7c/f2/7cf2afaf678438dd8b6d0c28c2256cbd_456x238.png) **注意:** 主庫需要開啟 binlog,從庫不是必須的。 ***** **部署:** 1. 修改主庫配置文件 ``` [mysqld] server‐id = 101 log‐bin = mysql‐bin ``` 2. 重啟mysql ``` service mysqld restart ``` 3. 修改從庫配置文件 ``` [mysqld] server‐id = 102 log‐bin = mysql‐bin ``` 4. 在主庫添加一個用戶 repl 并指定 replication 權限 ``` grant replication slave on *.* TO 'repl'@'%' identified by '123456'; ``` 5. 在主數據庫里面運行 show master status;記下 file 和 position 字段對應的參數。 ``` show master status; ``` 6. 在從庫設置它的 master: ``` change master to master_host='192.168.230.101', master_port=3306, master_user='repl', master_password='123456', master_log_file='mysql‐bin.000002', master_log_pos=437; ``` 7. 在從庫開啟從數據庫復制功能 ``` start slave; ``` 8. 在從庫可以通過 show slave status \G;來查看一些參數 ``` show slave status \G; ```
                  <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>

                              哎呀哎呀视频在线观看