I follow this article(http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p6) to configure mysql cluster with load balancing, but after I restart the load balancing server, I receive this error message error setting outbound mcast interface my current enviroment is mysql1, ip 192.168.1.170 mysql2, ip 192.168.1.171 load1, ip 192.168.1.178 (virtual ip is 192.168.1.177) load2, ip 192.168.1.179 I don't know what mcast should I use logfacility local0 bcast eth0 mcast eth0 225.0.0.1 694 1 0 auto_failback off node loadb1 node loadb2 respawn hacluster /usr/lib/heartbeat/ipfail apiauth ipfail gid=haclient uid=hacluster
Thanks for your reply I am not sure how can I check firewall setting ? I am a newbine to Linux, can you tell me who can I check it? and how can I turn that off?
I also have another question when I use /etc/ha.d/resource.d/LVSSyncDaemonSwap master status to check both load balancing server status, I found both of them are "master stopped", can you tell me which step I might do wrong that will cause this problem....? thanks again
Here is the result Code: Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination
I think I'd better to attach some other settings Load balancer 1 settings /etc/ha.d/ldirectord.cf Code: # Global Directives checktimeout=10 checkinterval=2 autoreload=no logfile="local0" quiescent=yes virtual = 192.168.1.177:3306 service = mysql real = 192.168.1.170:3306 gate real = 192.168.1.171:3306 gate checktype = negotiate login = "ldirector" passwd = "ldirectorpassword" database = "ldirectordb" request = "SELECT * FROM connectioncheck" scheduler = wrr lb1:~# cat /etc/ha.d/ha.cf Code: logfacility local0 bcast eth1 mcast eth1 225.0.0.1 694 1 0 auto_failback off node lb1 node lb2 respawn hacluster /usr/lib/heartbeat/ipfail apiauth ipfail gid=haclient uid=hacluster lb1:~# cat /etc/ha.d/haresources Code: lb1 \ ldirectord::ldirectord.cf \ LVSSyncDaemonSwap::master \ IPaddr2::192.168.1.177/24/eth1/192.168.1.255 lb1:~# nano /etc/network/Interfaces Code: # This file describes the network interfaces available on your system # and how to activate them. For more information, see interfaces(5). # The loopback network interface auto lo iface lo inet loopback # The primary network interface allow-hotplug eth1 iface eth1 inet static address 192.168.1.178 netmask 255.255.255.0 gateway 192.168.1.1 auto eth1:1 iface eth1:1 inet static address 192.168.1.177 netmask 255.255.255.255 gateway 192.168.1.1 lb1:~# sysctl -p Code: net.ipv4.ip_forward = 1 Load balancer 2 lb2:~# cat /etc/ha.d/ldirectord.cf Code: # Global Directives checktimeout=10 checkinterval=2 autoreload=no logfile="local0" quiescent=yes virtual = 192.168.1.177:3306 service = mysql real = 192.168.1.170:3306 gate real = 192.168.1.171:3306 gate checktype = negotiate login = "ldirector" passwd = "ldirectorpassword" database = "ldirectordb" request = "SELECT * FROM connectioncheck" scheduler = wrr lb2:~# cat /etc/ha.d/ha.cf Code: logfacility local0 bcast eth1 mcast eth1 225.0.0.1 694 1 0 auto_failback off node lb1 node lb2 respawn hacluster /usr/lib/heartbeat/ipfail apiauth ipfail gid=haclient uid=hacluster lb2:~# cat /etc/ha.d/haresources Code: lb1 \ ldirectord::ldirectord.cf \ LVSSyncDaemonSwap::master \ IPaddr2::192.168.1.177/24/eth1/192.168.1.255 nano /etc/network/interfaces Code: # This file describes the network interfaces available on your system # and how to activate them. For more information, see interfaces(5). # The loopback network interface auto lo iface lo inet loopback # The primary network interface allow-hotplug eth1 iface eth1 inet static address 192.168.1.179 netmask 255.255.255.0 gateway 192.168.1.1 lb2:~# sysctl -p Code: net.ipv4.ip_forward = 1