Re: sql-relay
What problem is that? I don't think there's much you can do beyond re-connecting, which Apache::DBI does. Well, the thing about SQLRelay is that it pools database connections, which is good when you want to have plenty of persistent connections to different databases. My only problem with it is that it doesn't seem to support prepared_cached statements... Cheers, -- IT'S TIME FOR A DIFFERENT KIND OF WEB Jean-Michel Hiver - Software Director [EMAIL PROTECTED] +44 (0)114 255 8097 VISIT HTTP://WWW.MKDOC.COM
sql-relay
List, I came across http://www.firstworks.com/sqlrelay.html the other day. Have any of you come across this product before. With the whole problem of providing seemless recovery at the client side from database failure this tool seems quite productive. I've not used it but figured maybe one of you has? Richard
Re: sql-relay
Richard Clarke wrote: I came across http://www.firstworks.com/sqlrelay.html the other day. Have any of you come across this product before. It's been discussed here before (see the archives) but no one has talked about any real experience with it yet. Try it out and tell us what you find. With the whole problem of providing seemless recovery at the client side from database failure this tool seems quite productive. What problem is that? I don't think there's much you can do beyond re-connecting, which Apache::DBI does. - Perrin
Re: sql-relay
Perrin Harkins wrote: Richard Clarke wrote: I came across http://www.firstworks.com/sqlrelay.html the other day. Have any of you come across this product before. It's been discussed here before (see the archives) but no one has talked about any real experience with it yet. Try it out and tell us what you find. With the whole problem of providing seemless recovery at the client side from database failure this tool seems quite productive. What problem is that? I don't think there's much you can do beyond re-connecting, which Apache::DBI does. I mean in the case of the database crashing and being able to switch to a replicated backup system. - Perrin
Re: sql-relay
Richard Clarke wrote: I mean in the case of the database crashing and being able to switch to a replicated backup system. That's trivial to implement if it happens during connect time. You can simply keep a list of databases to try, and if one fails you go on to the next. This approach is compatible with Apache::DBI, which will check database handles before handing them out to you. It will attempt a re-connect, and if it fails it will pass the failure message back to you just as if it were a normal connection attempt. It's harder if you want every query to be able to automatically retry on another database if it fails. For that, you would need to add some extra code to catch the exception, recognize it as a connection failure, make a new connection, and retry the query. I don't see anything on the SQL-Relay pages about this sort of ability. - Perrin