Re: [Sqlrelay-discussion] dynamically adding connections

[David M. <dav...@fi...>]

There is a dynamic scaling option.  In the sqlrelay.conf file, the
"connections" parameter defines the number of db connections that start
up when sqlrelay starts.  There's another parameter called
"maxconnections".  If it's greater than "connections", then new
connections will start up as-needed.  The "ttl" parameter determines how
long they will hang around if they go unused.  The "maxqueuelength"
parameter determines how many waiting clients must be queued up before
new connections will be started.  The "growby" parameter determines how
many new connections will be started when the maxqueuelength is
exceeded.

I believe that you can even set connections="0" and no connections will
be started when sqlrelay is started up.  In effect, it will be entirely
dynamic.

You should also be able to manually start sqlr-connection deamons if you
like, just by running them from the command line.  They will register
themselves with the sqlr-listener process and service requests just as
if they had been started by sqlr-start.

Hope this helps.

David Muse
dav...@fi...

On Mon, 2007-08-27 at 22:55 -0500, Duncan McQueen wrote:
> I looked thru the documentation and it appears that you define all the
> database connections at startup.  Is there a way to dynamically add
> new connections after sqlrelay has started?
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> _________________________________________________________________
> Need personalized email and website? Look no further. It's easy
> with Doteasy $0 Web Hosting! Learn more at www.doteasy.com