#1  
Old 14th April 2010, 22: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

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
Reply With Quote
Sponsored Links
Reply

Bookmarks

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 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
MySQL Cluster - Tables not synced tfunky Server Operation 4 6th April 2007 22:22
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55


All times are GMT +2. The time now is 23:19.


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