I was recently looking into the High Availability feature with Sybase and it seems to be a feature of the jdbc driver & server ( at least for Sybase ). I think your are correct and working with the connection pooling or jdbc driver group might be the way to go. Torque shouldn't really care about such things, right?
================================================================= Jeffrey D. Brekke Quad/Graphics [EMAIL PROTECTED] http://www.qg.com > -----Original Message----- > From: Howard Lin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 8:11 AM > To: 'Turbine Torque Users List' (E-mail) > Subject: using Torque to failover database > > > I'm wondering if anybody tried using Torque in a database > failover environment. For example, I can setup 2 MySQL > servers replicating each other but Torque only connects to > one of them. When that server failed, somehow Torque will > connect to the backup server. It seems this is more like a > question for connection pooling since Torque using that for > its connection. I would like to be able to supply multiple > database URL to the same database name and specify backup > order. This would seem like a great enhancement for Torque. > > Howard Lin > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
