users@glassfish.java.net

DB Failover mechanism using Sun App server

From: <glassfish_at_javadesktop.org>
Date: Thu, 05 Jun 2008 04:27:43 PDT

Hello

I look into a scenario like this:

Sun App server - Location A
DB server1 - Location A (active)
DB server2 - Location B (active)

If DB server1 is not available, then app server should fails over to DB server2.
Is this configuration possible in Sun App server? Is this possible to configure with connection pools?
As location A & B are connected thru WAN, MySql cluster based failover is not possible with the existing network configuration --:(

Thanks,
saji
[Message sent by forum member 'sajinvs' (sajinvs)]

http://forums.java.net/jive/thread.jspa?messageID=278509