Hello,
First, let me thank you for the great work that you are doing. I'm trying to set up a Mysql Cluster over AWS instances, but due to the limitations of Amazon(single ip /instance) i cannot use a virtual IP. So, i decided to setup a VPN network first so i can have all the IP that i need. I set up the VPN, all works fine regarding it. I followed the instructions in http://www.howtoforge.com/loadbalanc...cluster_debian in order to set up the cluster. I used debian lenny for the setup. The following IP addresses are used: 192.168.201.1 -load balancer 192.168.201.6 -sql1 192.168.201.10-sql2 192.168.201.100- Virtual IP On the load balacer node (only one, which is also the OpenVPN server ) i have the following: ha.cf Quote: logfacility local0 bcast tun0 mcast tun0 225.0.0.1 694 1 0 auto_failback off node <name provided by uname -n for this amazon instance> node loadb2 respawn hacluster /usr/lib/heartbeat/ipfail apiauth ipfail gid=haclient uid=hacluster haresources Quote: <name provided by uname -n for this amazon instance> \ ldirectord::ldirectord.cf \ LVSSyncDaemonSwap::master \ IPaddr2::192.168.201.100/24/tun0/192.168.201.255 ldirectord.cf Quote: # Global Directives checktimeout=10 checkinterval=2 autoreload=no logfile="local0" quiescent=yes virtual = 192.168.201.100:3306 service = mysql real = 192.168.201.6:3306 gate real = 192.168.201.10:3306 gate checktype = negotiate login = "ldirector" passwd = "ldirectorpassword121" database = "ldirectordb" request = "SELECT * FROM connectioncheck" scheduler = wrr A few checks reveal: ip addr sh tun0 Quote: 3: tun0: <POINTOPOINT,MULTICAST,NOARP,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UNKNOWN qlen 100 link/[65534] inet 192.168.201.1 peer 192.168.201.2/32 scope global tun0 inet 192.168.201.100/24 brd 192.168.201.255 scope global tun0 ipvsadm -L -n Quote: IP Virtual Server version 1.2.1 (size=4096) Prot LocalAddress:Port Scheduler Flags -> RemoteAddress:Port Forward Weight ActiveConn InActConn TCP 192.168.201.100:3306 wrr -> 192.168.201.6:3306 Route 1 0 0 -> 192.168.201.10:3306 Route 1 0 0 /etc/ha.d/resource.d/LVSSyncDaemonSwap master status master running (ipvs_syncmaster pid: 1474) ldirectord ldirectord.cf status ldirectord for /etc/ha.d/ldirectord.cf is running with pid: 1391 However, when i try to connect to the virtual ip i get the following Quote: mysql -h 192.168.201.100 -u ldirector -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.201.100' (111) What am i doing wrong? Is The fact that i'm running it over VPN? Thanks, Catalin _______________________________________________ Please read the documentation before posting - it's available at: http://www.linuxvirtualserver.org/ LinuxVirtualServer.org mailing list - [email protected] Send requests to [email protected] or go to http://lists.graemef.net/mailman/listinfo/lvs-users
