Old 14th April 2010, 23:34
bacterie bacterie is offline
Junior Member
Join Date: Apr 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql Cluster over VPN


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: -load balancer -sql1 Virtual IP

On the load balacer node (only one, which is also the OpenVPN server ) i have the following:

logfacility local0
bcast tun0
mcast tun0 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
<name provided by uname -n for this amazon instance> \
ldirectord::ldirectord.cf \
LVSSyncDaemonSwap::master \

# Global Directives

virtual =
service = mysql
real = gate
real = gate
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword121"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr

A few checks reveal:

ip addr sh tun0
3: tun0: <POINTOPOINT,MULTICAST,NOARP,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UNKNOWN qlen 100
inet peer scope global tun0
inet brd scope global tun0
ipvsadm -L -n
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP wrr
-> Route 1 0 0
-> 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
mysql -h -u ldirector -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '' (111)
What am i doing wrong? Is The fact that i'm running it over VPN?
Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
MySQL Cluster - Tables not synced tfunky Server Operation 4 6th April 2007 23:22
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 18:37
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 05:55

All times are GMT +2. The time now is 13:32.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.