溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶(hù)服務(wù)條款》
您好，登錄后才能下訂單哦！
不知道大家之前對(duì)類(lèi)似MySQL高可用架構(gòu)MHA的部署及測(cè)試的文章有無(wú)了解，今天我在這里給大家再簡(jiǎn)單的講講。感興趣的話(huà)就一起來(lái)看看正文部分吧，相信看完MySQL高可用架構(gòu)MHA的部署及測(cè)試你一定會(huì)有所收獲的。
MHA(Master HA)是一款開(kāi)源的MySQL的高可用程序，它為MySQL主從復(fù)制架構(gòu)提供了automating master failover功能。MHA在監(jiān)控到master節(jié)點(diǎn)故障時(shí)，會(huì)提升其中擁有的最新數(shù)據(jù)的slave節(jié)點(diǎn)成為新的master節(jié)點(diǎn)，在此期間，MHA會(huì)通過(guò)其它從節(jié)點(diǎn)獲取額外信息來(lái)避免一致性方面的問(wèn)題。MHA還提供了master節(jié)點(diǎn)的在線(xiàn)切換功能，即按需切換master/slave節(jié)點(diǎn)。
MHA服務(wù)有兩種角色，MHA Manager(管理節(jié)點(diǎn))和MHA Node(數(shù)據(jù)節(jié)點(diǎn))：
MHA Manager：通常單獨(dú)部署在一臺(tái)獨(dú)立機(jī)器上管理多個(gè)master/slave集群，每個(gè)master/slave集群稱(chēng)為一個(gè)application； MHA node：運(yùn)行在每臺(tái)MySQL云服務(wù)器上，它通過(guò)監(jiān)控具備解析和清理log功能的腳本來(lái)加快故障轉(zhuǎn)移
Manager節(jié)點(diǎn)：
-masterha_check_ssh：MHA依賴(lài)的SSH環(huán)境檢測(cè)工具； -masterha_check_repl:MySQL復(fù)制環(huán)境檢測(cè)工具； -masterha_manager:MHA服務(wù)主程序； -masterha_check_status:MHA運(yùn)行狀態(tài)探測(cè)工具； -masterha_master_monitor：MySQL master節(jié)點(diǎn)可用性檢測(cè)工具； -masterha_master_switch:master節(jié)點(diǎn)切換工具； -masterha_conf_host:添加或刪除配置的節(jié)點(diǎn)； -masterha_stop：關(guān)閉MHA服務(wù)的工具；
Node節(jié)點(diǎn)：
-save_binary_logs：保存和復(fù)制master的二進(jìn)制日志； -apply_diff_relay_logs:識(shí)別差異的中繼日志事件并用于其他slave； -fiter_mysqlbinlog：去除不必要的ROLLBACK事件(MHA已不再使用這個(gè)工具)； -purge_relay_logs：清除中繼日志(不會(huì)阻塞SQL線(xiàn)程)；
自定義擴(kuò)展：
-secondary_check_script：通過(guò)多條網(wǎng)絡(luò)路由檢測(cè)master的可用性； -master_ip_failover_script:更新appliction使用的masterip； -shutdown_script:強(qiáng)制關(guān)閉master節(jié)點(diǎn)； -report_script:發(fā)送報(bào)告； -init_conf_load_script：加載初始配置參數(shù)； -master_ip_online_change_script:更新master節(jié)點(diǎn)ip地址
實(shí)驗(yàn)拓?fù)洌?/p>
node1:192.168.150.137 MHA manager node2:192.168.150.138 MHA node mariadb master node3:192.168.150.139 MHA node mariadb slave candidate node4:192.168.150.140 MHA node mariadb slave
配置過(guò)程：
1、修改每臺(tái)云服務(wù)器的hosts文件 /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.150.137 node1.com node1 192.168.150.138 node2.com node2 192.168.150.139 node3.com node3 192.168.150.140 node4.com node4 2、node2-node4進(jìn)行mariadb的yum安裝 yum -y install mariadb-server 3、配置ssh互信通信環(huán)境 [root@node1 ~]# ssh-keygen -t rsa -P '' Generating public/private rsa key pair. Enter file in which to save the key (/root/.ssh/id_rsa): Created directory '/root/.ssh'. Your identification has been saved in /root/.ssh/id_rsa. Your public key has been saved in /root/.ssh/id_rsa.pub. The key fingerprint is: a2:f2:10:28:cd:ea:7b:d8:f4:95:15:6e:73:a6:9d:4e root@node1.com The key's randomart p_w_picpath is: +--[ RSA 2048]----+ | | | . | | . . | | + = o | |o + . S * . | |.. o . + . E | |. * o . o | |.. * . . | | oo . | +-----------------+ [root@node1 ~]# ls .ssh/id_rsa id_rsa id_rsa.pub [root@node1 ~]# cat .ssh/id_rsa.pub > .ssh/authorized_keys [root@node1 ~]# ssh node1 The authenticity of host 'node1 (192.168.150.137)' can't be established. ECDSA key fingerprint is 2a:e3:03:52:8c:84:02:59:a2:26:a3:b2:f6:74:6c:3c. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'node1,192.168.150.137' (ECDSA) to the list of known hosts. Last login: Wed Mar 29 15:06:52 2017 from 192.168.150.1 [root@node1 ~]# ll .ssh/authorized_keys -rw-r--r-- 1 root root 396 3月 29 15:35 .ssh/authorized_keys [root@node1 ~]# chmod go= .ssh/authorized_keys [root@node1 ~]# scp -p .ssh/id_rsa .ssh/authorized_keys node2:/root/.ssh root@node2's password: id_rsa 100% 1675 1.6KB/s 00:00 authorized_keys 100% 396 0.4KB/s 00:00 [root@node1 ~]# scp -p .ssh/id_rsa .ssh/authorized_keys node3:/root/.ssh The authenticity of host 'node3 (192.168.150.139)' can't be established. ECDSA key fingerprint is 2a:e3:03:52:8c:84:02:59:a2:26:a3:b2:f6:74:6c:3c. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'node3,192.168.150.139' (ECDSA) to the list of known hosts. root@node3's password: id_rsa 100% 1675 1.6KB/s 00:00 authorized_keys 100% 396 0.4KB/s 00:00 [root@node1 ~]# scp -p .ssh/id_rsa .ssh/authorized_keys node4:/root/.ssh root@node4's password: Permission denied, please try again. root@node4's password: id_rsa 100% 1675 1.6KB/s 00:00 authorized_keys 100% 396 0.4KB/s 00:00 [root@node1 ~]# ssh node2 Last login: Wed Mar 29 15:07:05 2017 from 192.168.150.1 [root@node2 ~]# exit 登出 Connection to node2 closed. [root@node1 ~]# ssh node3 Last login: Wed Mar 29 15:07:18 2017 from 192.168.150.1 [root@node3 ~]# exit 登出 Connection to node3 closed. [root@node1 ~]# ssh node3 Last login: Wed Mar 29 15:40:05 2017 from node1.com [root@node3 ~]# exit 登出 Connection to node3 closed. [root@node1 ~]# ssh node4 Last failed login: Wed Mar 29 15:39:53 CST 2017 from node1.com on ssh:notty There was 1 failed login attempt since the last successful login. Last login: Wed Mar 29 15:39:30 2017 from node1.com [root@node4 ~]# exit 登出 Connection to node4 closed. [root@node1 ~]# ssh node4 Last login: Wed Mar 29 15:40:13 2017 from node1.com [root@node4 ~]# exit 登出 Connection to node4 closed. 4、修改mysql參數(shù) master： [mysqld] innodb_file_per_table = 1 skip_name_resolve = 1 log-bin = master-bin relay-log = relay-bin server_id = 1 slave： [mysqld] innode_file_per_table = 1 skip_name_resolve = 1 log-bin = master-bin relay-log = relay-bin server_id = 2 read_only = 1 relay_log_purge = 0 5、主庫(kù)開(kāi)啟并創(chuàng)建授權(quán)賬號(hào) master: MariaDB [(none)]> SHOW MASTER STATUS; +-------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------+----------+--------------+------------------+ | master-bin.000003 | 245 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'repluser'@'192.168.%.%' IDENTIFIED BY 'replpass'; MariaDB [(none)]> GRANT ALL ON *.* TO 'mhauser'@'192.168.%.%' IDENTIFIED BY 'mhapass'; #此為mha的管理賬號(hào) MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'read_only'; #此時(shí)主庫(kù)是可寫(xiě)可讀 +---------------+-------+ | Variable_name | Value | +---------------+-------+ | read_only | OFF | +---------------+-------+ 1 row in set (0.00 sec) 6、從庫(kù)進(jìn)行主從功能開(kāi)啟 node3、node4操作相同 [root@node3 ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.52-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CHANGE MASTER TO MASTER_HOST='192.168.150.138',MASTER_USER='repluser',MSTER_PASSWORD='replpass',MASTER_LOG_FILE='master-bin.000003',MASTER_LOG_POS=245; Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 192.168.150.138 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-bin.000003 Read_Master_Log_Pos: 245 Relay_Log_File: relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: master-bin.000003 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 245 Relay_Log_Space: 245 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 1 row in set (0.00 sec) MariaDB [(none)]> START SLAVE; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.150.138 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-bin.000003 Read_Master_Log_Pos: 497 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 782 Relay_Master_Log_File: master-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 497 Relay_Log_Space: 1070 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 1 row in set (0.00 sec) MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'read_only'; #此時(shí)從庫(kù)是只讀模式 +---------------+-------+ | Variable_name | Value | +---------------+-------+ | read_only | ON | +---------------+-------+ 1 row in set (0.00 sec) 7、此時(shí)一主兩從架構(gòu)已經(jīng)配置完成，安裝MHA包 manager節(jié)點(diǎn)(node1)： 安裝mha4mysql-manager-0.56-0.el6.noarch.rpm和mha4mysql-node-0.56-0.el6.noarch.rpm yum install mha4mysql* -y node節(jié)點(diǎn)(node2-node4): 安裝mha4mysql-node-0.56-0.el6.noarch.rpm yum -y iinstall mha4mysql-node-0.56-0.el6.noarch.rpm 8、初始化MHA 創(chuàng)建配置目錄及配置文件(在node1上執(zhí)行) [root@node1 ~]# mkdir /etc/masterha [root@node1 ~]# vim /etc/masterha/app1.cnf [server default] user=mhauser password=mhapass manager_workdir=/data/masterha/app1 master_log=/data/masterha/app1/manager.log remote_workdir=/data/masterha/app1 ssh_user=root repl_user=repluser repl_password=replpass ping_interval=1 [server1] hostname=192.168.150.138 candidate_master=1 [server2] hostname=192.168.150.139 candidate_master=1 [server3] hostname=192.168.150.140 9、啟動(dòng)前檢測(cè) ssh互信配置是否OK [root@node1 ~]# masterha_check_ssh --conf=/etc/masterha/app1.cnf ...... Warning: Permanently added '192.168.150.139' (ECDSA) to the list of known hosts. Wed Mar 29 17:03:03 2017 - [debug] ok. Wed Mar 29 17:03:03 2017 - [info] All SSH connection tests passed successfully. mysql復(fù)制集群的連接配置是否OK [root@node1 ~]# masterha_check_repl --conf=/etc/masterha/app1.cnf ...... Wed Mar 29 17:04:40 2017 - [info] 192.168.150.138(192.168.150.138:3306) (current master) +--192.168.150.139(192.168.150.139:3306) +--192.168.150.140(192.168.150.140:3306) Wed Mar 29 17:04:40 2017 - [info] Checking replication health on 192.168.150.139.. Wed Mar 29 17:04:40 2017 - [info] ok. Wed Mar 29 17:04:40 2017 - [info] Checking replication health on 192.168.150.140.. Wed Mar 29 17:04:40 2017 - [info] ok. Wed Mar 29 17:04:40 2017 - [warning] master_ip_failover_script is not defined. Wed Mar 29 17:04:40 2017 - [warning] shutdown_script is not defined. Wed Mar 29 17:04:40 2017 - [info] Got exit code 0 (Not master dead). MySQL Replication Health is OK. 10、啟動(dòng)MHA [root@node1 ~]# nohup masterha_manager --conf=/etc/masterha/app1.cnf > /data/masterha/app1/manager.log 2>& 1 &[1] 16989 [root@node1 ~]# tail -f /data/masterha/app1/manager.log 192.168.150.138(192.168.150.138:3306) (current master) +--192.168.150.139(192.168.150.139:3306) +--192.168.150.140(192.168.150.140:3306) Wed Mar 29 21:51:58 2017 - [warning] master_ip_failover_script is not defined. Wed Mar 29 21:51:58 2017 - [warning] shutdown_script is not defined. Wed Mar 29 21:51:58 2017 - [info] Set master ping interval 1 seconds. Wed Mar 29 21:51:58 2017 - [warning] secondary_check_script is not defined. It is highly recommended setti ng it to check master reachability from two or more routes.Wed Mar 29 21:51:58 2017 - [info] Starting ping health check on 192.168.150.138(192.168.150.138:3306).. Wed Mar 29 21:51:58 2017 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond.. 11、啟動(dòng)后查看master節(jié)點(diǎn)狀態(tài) [root@node1 ~]# masterha_check_status --conf=/etc/masterha/app1.cnf app1 (pid:16623) is running(0:PING_OK), master:192.168.150.138 12、進(jìn)行故障轉(zhuǎn)移測(cè)試 (1)maser節(jié)點(diǎn)關(guān)閉mariadb [root@node2 ~]# killall mysqld mysqld_safe (2)此時(shí)在manager上可以看到轉(zhuǎn)移的日志 ----- Failover Report ----- app1: MySQL Master failover 192.168.150.138(192.168.150.138:3306) to 192.168.150.139(192.168.150.139:3306) succeeded Master 192.168.150.138(192.168.150.138:3306) is down! Check MHA Manager logs at node1.com:/data/masterha/app1/manager.log for details. Started automated(non-interactive) failover. The latest slave 192.168.150.139(192.168.150.139:3306) has all relay logs for recovery. Selected 192.168.150.139(192.168.150.139:3306) as a new master. 192.168.150.139(192.168.150.139:3306): OK: Applying all logs succeeded. 192.168.150.140(192.168.150.140:3306): This host has the latest relay log events. Generating relay diff files from the latest slave succeeded. 192.168.150.140(192.168.150.140:3306): OK: Applying all logs succeeded. Slave started, replicating from 19 2.168.150.139(192.168.150.139:3306)192.168.150.139(192.168.150.139:3306): Resetting slave info succeeded. Master failover to 192.168.150.139(192.168.150.139:3306) completed successfully. 故障轉(zhuǎn)移后，manager會(huì)自動(dòng)停止，此時(shí)查看master狀態(tài) [root@node1 ~]# masterha_check_status --conf=/etc/masterha/app1.cnf app1 is stopped(2:NOT_RUNNING). (3)查看其它兩個(gè)庫(kù)狀態(tài) node3 已成功接管master，并可讀寫(xiě) MariaDB [(none)]> SHOW MASTER STATUS; +-------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------+----------+--------------+------------------+ | master-bin.000003 | 245 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'read_only'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | read_only | OFF | +---------------+-------+ 1 row in set (0.00 sec) node4 MariaDB [(none)]> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.150.139 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-bin.000003 Read_Master_Log_Pos: 245 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 530 Relay_Master_Log_File: master-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 245 Relay_Log_Space: 818 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 2 1 row in set (0.00 sec) MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'read_only'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | read_only | ON | +---------------+-------+ 1 row in set (0.00 sec) (4)提供新的從節(jié)點(diǎn)已修復(fù)復(fù)制集群 master界定啊故障后，需要重新準(zhǔn)備好一個(gè)新的MySQL節(jié)點(diǎn)。基于來(lái)自于master節(jié)點(diǎn)的備份恢復(fù)后，將其重新配置為mster的從節(jié)點(diǎn)即可。新加入節(jié)點(diǎn)IP為原master節(jié)點(diǎn)IP，否則還得修改appl.cnf中相應(yīng)的設(shè)置，最后再次啟動(dòng)manager，并再次檢查狀態(tài)。 [root@node2 ~]# rm -rf /var/lib/mysql/* [root@node2 ~]# vim /etc/my.cnf 添加從庫(kù)兩選項(xiàng) read_only = 1 relay_log_purge = 0 [root@node2 ~]# systemctl start mariadb.service [root@node2 ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.52-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'repluser'@'192.168.%.%' IDENTIFIED BY 'replpass';Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> GRANT ALL ON *.* TO 'mhauser'@'192.168.%.%' IDENTIFIED BY 'mhapass'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> CHANGE MASTER TO MASTER_HOST='192.168.150.139',MASTER_USER='repluser',MASTER_PASSWORD='r eplpass',MASTER_LOG_FILE='master-bin.000003',MASTER_LOG_POS=245; Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> SHOW SLAVE\G ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaD B server version for the right syntax to use near '' at line 1MariaDB [(none)]> START SLAVE; Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.150.139 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-bin.000003 Read_Master_Log_Pos: 245 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 530 Relay_Master_Log_File: master-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 245 Relay_Log_Space: 818 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 2 1 row in set (0.00 sec) 再次開(kāi)啟manager查看狀態(tài)，狀態(tài)全部OK，主庫(kù)變更為node3 [root@node1 ~]# nohup masterha_manager --conf=/etc/masterha/app1.cnf > /data/masterha/app1/manager.log 2>&1 & [root@node1 ~]# masterha_check_status --conf=/etc/masterha/app1.cnf app1 (pid:17229) is running(0:PING_OK), master:192.168.150.139
看完MySQL高可用架構(gòu)MHA的部署及測(cè)試這篇文章，大家覺(jué)得怎么樣？如果想要了解更多相關(guān)，可以繼續(xù)關(guān)注我們的行業(yè)資訊板塊。
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼
