Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danpets
Starting Member
1 Post |
 Posted - 2008-10-23 : 12:12:30
|
| All, we are in the process of setting mirroring for HA and have runinto issue of client connectivity with mirrored database.we are using jdbc with connection pooling. and our jdbc doesn't provide automatic failover fucntionality.one possible solution is to have a load balancer between our app server and database server. So that jdbc is configured to a virtual ip and the loadbalancer will route it to the right database machine.if this will owrk, the question is how will the loadbalancer know mirrored database is not available? the mirrored database - service is up but database is in restore state.any suggestions?thank youdan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-23 : 14:01:13
|
| http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx |
 |
|
|
|
|
|
Mirroring and loadbalancer?