Mysql Cluster over VPN

Discussion in 'HOWTO-Related Questions' started by bacterie, Apr 14, 2010.

  1. bacterie

    bacterie New Member

    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/loadbalanced_mysql_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
    haresources
    ldirectord.cf
    A few checks reveal:

    ip addr sh tun0
    ipvsadm -L -n
    /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
    What am i doing wrong? Is The fact that i'm running it over VPN?
    Thanks,
    Catalin
     

Share This Page