Forum Discussion

mfkk531_168091's avatar
mfkk531_168091
Icon for Nimbostratus rankNimbostratus
Aug 18, 2015

Best Load Balancing Method to Load Balance Database servers?

HI All, I have a pool with 2 members (database servers) currently using Round Robin, and server guys say the distribution is not even. We tried Least Connection (member, no other pool is using this node) and he sees more connections are going to one of the pool member.

 

So I wanted to get any ideas, which LB method will be bst, if one requests completes in 10s and the other could complete in 30 min (these are database lookups and size/time vary signficantly from one connection to the next.)

 

Thanks in advance

 

application delivery
LTM
management
oracle
performance
TMOS

5 Replies

  • DMA_95966's avatar
    DMA_95966
    Icon for Nimbostratus rankNimbostratus
    Aug 18, 2015

    Hi ,

     

    Can you provide more details regarding your setup , like if DB is in cluster or not ?

     

    Thanks ,

     

    Deepak

     

  • mfkk531_168091's avatar
    mfkk531_168091
    Icon for Nimbostratus rankNimbostratus
    Aug 18, 2015

    Hi Deepak, Below is my load balancer configuration -

    ltm virtual vs-prestogetherx {
destination 172.29.60.212:any
ip-protocol tcp
mask 255.255.255.255
pool p-prestogetherx
profiles {
    tcp { }
}
snat automap
translate-port disabled
vlans-disabled
}

    Here is pool config -

    ltm pool p-prestogetherx {
members {
    DLV2-AP1-COM:any {
        address 172.29.19.126
        session monitor-enabled
        state up
    }
    DLV2-AP2-COM:any {
        address 172.29.19.127
        session monitor-enabled
        state up
    }
}
monitor m-prestogetherx
service-down-action reset
slow-ramp-time 0

    }

    I checked with database folks and they say each of this node is a separate server (not a cluster). They are using F5 to load balance between 2 individual database servers

    Thanks,

  • DMA_95966's avatar
    DMA_95966
    Icon for Nimbostratus rankNimbostratus
    Aug 19, 2015

    Hi ,

     

    So both databases are read only ? And I am assuming you are not using any persistence here ?

     

  • DMA_95966's avatar
    DMA_95966
    Icon for Nimbostratus rankNimbostratus
    Aug 19, 2015

    Hmm.. Round robin should work then . Just guess may be server team checking CPU/memory usage of server and saying about uneven distribution . Do you know how they are measuring/counting connections to individual server ?