Re: [Sqlrelay-discussion] (new to sqlrelay) : authtier description : what does this mean ?

[Firstworks/4access <dav...@fi...>]

Sorry, I missed this email :)

A connection daemon only closes and reopens the connection if a client
tries to authenticate as a different user than the previous client
authenticated as when authtier=database and when you're not using Oracle
or MySQL.

When authtier=listener or authtier=connection or
authtier="listener and connection" (which are much more common) then the
connection deamon does not close and reopen the connection to the
database, rather it logs into the database when it starts up and stays
logged in as long as it's running.

When using authtier=database, the client can log into the sqlrelay
server as one of the users defined in the database rather than a user
defined in the sqlrelay.conf file.  Oracle and MySQL provide efficient
methods for switching users while remaining logged into the database but
other databases do not (as far as I know).  When using authtier=database
and an Oracle or MySQL database, authtier=database is pretty efficient,
but when using a different database, it's less efficient if lots of
different users use the database.

David Muse
dav...@fi...

On Tue, 2005-05-31 at 13:54 +0200, santiago wrote:
> Hello
> 
> I was looking for a database connection pooling and found
> sqlrelay.
> 
> It looks great !
> 
> I'm reading the configuring help at :
> 
> http://sqlrelay.sourceforge.net/sqlrelay/configuring.html
> 
> there's something I dont understand (I'm not native englis speaker,
> maybe that's the reason)
> 
> in section : Authtier
> 
> >When SQL Relay is used with any other database, it simply logs out and
> >logs back in as a different user. This is quite ineffecient and defeats
> >the value of keeping persistent database connections.
> 
> I don't get it : does it mean that the connection deamons close and
> reopen connections each time the listenner handles a user to them ?
> I'm sure that's not the correct interpretation, because to me,
> it means that the client would be just as performent by just openning
> a new connection by himself.
> 
> what did I get wrong ?
> 
> 
> thanks
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>