Hello Everyone,

I have a working MySQL cluster which is based on 2 nodes.

Now on my 3rd server i want to use it as a Load balancer for the MySQL cluster.

As, i do not have that much experience in load balancing part so i Google for it and i finally made my configuration file.

Kindly take a look at the attached config file.

And please tell me if i am missing some parameters.

Thanks,
usmangt

Since, in the forum the file attachment is not working so i am pasting it in here

global_defs {

    router_id OX

}



vrrp_sync_group OX_GROUP {

    group {

        OX_GOUP

    }

}



vrrp_instance OX_VRRP {

    state BACKUP

    interface eth0

    garp_master_delay 10

    virtual_router_id 10

    priority 101

    nopreempt

    advert_int 1

    authentication {

        auth_type PASS   # Simple 'PASS' can use

        auth_pass example # example password '1234'

    }

    virtual_ipaddress {

        10.10.10.249/24 brd 10.10.10.255 dev eth0 # virtual service ip 10.10.10.249

    }

    virtual_ipaddress_excluded {

    }

}



virtual_server_group OX_HTTP {

        10.10.10.249 3306         # virtual ip and port 3306

}



virtual_server group OX_HTTP {

    delay_loop 3

    lvs_sched  rr

    lvs_method DR

    protocol   TCP

    virtualhost 10.10.10.249



    real_server 10.10.10.187 3306 {

        weight 1

        inhibit_on_failure

        TCP_CHECK {

            connect_port 3306

            connect_timeout 10

        }

    }



    real_server 10.10.10.189 3306 {

        weight 1

        inhibit_on_failure

        TCP_CHECK {

            connect_port 3306

            connect_timeout 10

        }

    }

}