Welcome to the Linux Foundation Forum!

Using keepalived load balancer for the MySQL Cluster

Options
usmangt
usmangt Posts: 42
edited August 2012 in Network Management

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

Comments

  • usmangt
    usmangt Posts: 42
    Options
    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
            }
        }
    }
    

Categories

Upcoming Training