Forum Discussion

Bastien_8356's avatar
Bastien_8356
Icon for Nimbostratus rankNimbostratus
Apr 12, 2011

How 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 !

 

config
design
  • hwidjaja_37598's avatar
    hwidjaja_37598
    Icon for Altostratus rankAltostratus
    Apr 12, 2011
    Can you try this:

     

     

    b pool db_pool { member 10.10.1.110:mysql { limit 1234 } }

     

     

    '1234' is the connection limit
  • Haluk_Yildirim_'s avatar
    Haluk_Yildirim_
    Icon for Nimbostratus rankNimbostratus
    Apr 12, 2011
    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's avatar
    Bastien_8356
    Icon for Nimbostratus rankNimbostratus
    Apr 12, 2011
    @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_37598's avatar
    hwidjaja_37598
    Icon for Altostratus rankAltostratus
    Apr 12, 2011
    Hi 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

     

     

  • hwidjaja_37598's avatar
    hwidjaja_37598
    Icon for Altostratus rankAltostratus
    Apr 12, 2011
    If 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 :)