Re: [Sqlrelay-discussion] dynamically adding connections

[Duncan M. <dwm...@gm...>]

David,

So (at least in theory) I could have spare machines that upon boot
(after running a simple process to make sure their data is up-to-date)
they could register themselves with the sql-relay central process and
be ready to accept queries?

Thanks,

Duncan

On 8/30/07, David Muse <dav...@fi...> wrote:
> 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
>
>
> -------------------------------------------------------------------------
> 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
>