<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 功能強大 支持多語言、二開方便! 廣告
                ## **主節點 master** 1. 編輯 my.cnf ``` vim /www/server/mysql/my.cnf # 寶塔 8.0 vim /etc/my.cnf ``` 2. 在對應位置添加如下內容: ``` [mysqld] server-id=1 log-bin=mysql-bin binlog-do-db=energy ``` 3. 重啟 mysqld 服務: ``` service mysqld restart ``` 3. 進入mysql 創建用于同步的賬號: ``` # 創建 slave 從服務器連接賬號 grant replication slave on *.* to 'salve'@'192.168.144.111' identified by '123456'; # 刷新用戶權限 flush privileges; ``` ``` grant all privileges on *.* to 'wangqianshun'@'%' identified by 'wangqianshun';flush privileges; ``` 4. 查看主節點(master)節點狀態: ``` show master status; ``` ![](https://img.kancloud.cn/0a/dc/0adc386af92e34b03446f9b99ec181b3_616x115.png) ***** ## **從節點 master** **參數介紹:** | 參數 | 描述 | | --- | --- | | server-id=1 | 當前Mysql服務器標識 | | log-bin=mysql-bin | 開啟二進制bin-log日志 | | relay-log=relay-bin | 中繼日志文件的路徑名稱 | | relay-log-index=relay-bin | 中繼日志索引文件的路徑名稱 | | read_only=1 | 使數據庫只讀,可以保證slave只接受master的更新,而不接受client的更新。 | | skip_slave_start | 使slave在mysql啟動時不啟動復制進程,mysql起來之后使用 start slave啟動,建議必須 | | replicate-do-db | 只復制指定數據庫 | | replicate-do-table | 只復制指定表 | | replicate-ingore-table | 忽略指定表 | | max_relay_log_size | slave上的relay log的大小,默認是1G| | relay_log_info_file | 中繼日志狀態信息文件的路徑名稱 | | relay_log_purge | 當relay log不被需要時就刪除,默認是on | | log_slave_updates | 同master節點作用相同 | ***** 1. 編輯 my.cnf ``` vim /www/server/mysql/my.cnf # 寶塔 8.0 vim /etc/my.cnf ``` 2. 在對應位置添加如下內容: ``` [mysqld] server-id=2 log-bin=master-bin replicate-do-db=energy # 該配置如果在 keepalived 不要設置 read_only=1 ``` 3. 重啟 mysqld 服務: ``` service mysqld restart ``` 4. 執行執行連接主服務器命令: <span style="color:red"><b> 注:</b></span> keepalived 下請配置 host 為虛擬ip(不要寫成 master 物理ip) <span style="color:red"><b> 注:</b></span> 并且 master 和 backup 都要創建一模一樣的用戶(不然當 master 掛了 漂移到 backup 主從會失敗連接不上) ``` change master to master_host='192.168.144.110',master_user='slave',master_password='123456',master_log_file='mysql-bin.000009',master_log_pos=120; ``` 5. 啟動 slave 同步 ``` start slave; ``` 6. 查看 ``` show slave status \G; ``` ![](https://img.kancloud.cn/a5/9b/a59b19498ca919162bd4f1a9e343618d_478x347.png) ***** ## **從庫命令:** 停止 slave ``` stop slave; ``` 重置 slave 配置 ``` reset slave; ``` ?
                  <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>

                              哎呀哎呀视频在线观看