Using keepalived load balancer for the MySQL Cluster

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
        }
    }
}