Hi Howard,
Take a look at SQL Relay: http://www.firstworks.com/sqlrelay.html You should be able to set this up so that Torque connects to an SQL Relay proxy with the proxy maintaining the actual connections to the database. I have never used SQL Relay myself, but I have heard good things about it, so it would be good if you could report your findings back to this list. Here at the ACTF, we use Heartbeat and DRBD (from http://www.linux-ha.org/) for our high availability setup. Our MySQL databases write to a mirrored DRBD partition, so it was not necessary for us to use MySQL replication. Hope that helps, -- Rodney On Tue, 17 Sep 2002 23:11, you wrote: > 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]>
