Forum Discussion
Bastien_8356
Nimbostratus
NimbostratusHow to add members in a pool with connection limit ?
Hi,
I'm trying to add members to my pool in command-line because in the GUI it's one by one...
So I tried :
[root@F5-DB:Offline] config b pool db_pool {member 10.10.1.110:mysql}
BIGpipe pool modification error:
0107007a:3: The weighted least connections algorithm for pool (db_pool) requires all pool members to have a connection limit.
I don't find anywhere how to add this connection limit.
Is there a way to add a range of member in 1 shot ?
Thanks for your help !
hwidjaja_37598Altostratus
Can you try this:
b pool db_pool { member 10.10.1.110:mysql { limit 1234 } }
'1234' is the connection limit
Haluk_Yildirim_Hello:
The way I handle b commands is to reverse engineer from the configuration.
b pool POOL-WRR list
pool POOL-WRR {
monitor all MON-TCP-80
members {
192.168.15.100:http {
limit 200
}
192.168.15.110:http {
limit 300
}
}
}
To add a member with the connection limit, I use the following command (pretty much read it from the top)
b pool POOL-WRR members 192.168.15.120:http limit 200 add
Bastien_8356@hwidjaja, I tried : b pool db_pool {member xxxx:mysql limit 50 } , it erase all node in the pool lol
@Haluck, thanks that worked, I didn't know that by just reading the config from the top equasl the command to use, very helpful thank you !- hwidjaja_37598Hi Bastien,
I actually adopted the command from your previous one :)
Btw, You can put 'add' parameter to add instead of overwriting the config; eg.
b pool db_pool { member 10.10.1.110:mysql { limit 1234 } } add - Bastien_8356So the { } are optional, worked without them. We learn every day =)
- hwidjaja_37598If you have more complex members/parameters to add then I would suggest to use { } block.
Don't hesitate to ask for help, we're here to learn together :)