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 ...
application delivery
LTM
management
oracle
performance
TMOS
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,