MMM高可用测试.docVIP

MMM高可用测试 by Jcr.Cui 一、双主零从 ============================================================== 主机： 功能 IP 主机名 monitor 10.1.30.216 mysql-3 DB db6 Server-id=6 10.1.30.226 net-1 db7 Server-id=7 10.1.30.230 net-2 虚拟ip： IP0 10.1.30.219 (Write) IP1 10.1.30.221 (Read) IP2 10.1.30.243 (Read) 虚拟ip --------------------[1] mmm_common.conf -------------------- active_master_role writer host default cluster_interface eth0 #网卡，如果配置错误mmm会自动修正 pid_path /var/run/mmm_agentd.pid bin_path /usr/lib/mysql-mmm/ replication_user repl replication_password repl agent_user mmm_agent agent_password mmm_agent /host host db6 ip 10.1.30.226 mysql_port 3306 mode master peer db7 /host host db7 ip 10.1.30.230 mysql_port 3306 mode master peer db6 /host role writer hosts db6, db7 #能够作为writer的host ips 10.1.30.219 #writer的虚拟IP，应用的写请求直接访问这里的ip即可 mode exclusive #只有两种模式：exclusive是排他，在这种模式下任何时候只能一个host拥有该角色，balanced模式下可以多个host同时拥有此角色。一般writer是ex，reader是ba /role role reader hosts db6, db7 #能够作为reader的host ips 10.1.30.221, 10.1.30.243 #reader的虚拟IP，应用的读请求直接访问这里的ip即可 mode balanced /role --------------------[2] mmm_mon.conf ----------------------- include mmm_common.conf monitor ip 10.1.30.216 pid_path /var/run/mmm_mond.pid bin_path /usr/lib/mysql-mmm/ status_path /var/lib/misc/mmm_mond.status ping_ips 10.1.30.214, 10.1.30.215, 10.1.30.226, 10.1.30.230 /monitor host default monitor_user mmm_mon monitor_password mmm_mon /host debug 0 ---------