| Author |
Topic |
|
daimne
Starting Member
17 Posts |
 Posted - 2008-10-14 : 11:46:01
|
| I'm trying to add to my practical experience on setting HA - Mirroring vs clustering.Any practical opinion will be appreciated!TIA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 11:49:46
|
| Did you search in google or Microsoft whitepaper regarding it? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
daimne
Starting Member
17 Posts |
Posted - 2008-10-14 : 14:02:05
|
| Tara thank you!will appreciate brief - one paragrap response. I know, lots of factors may be important to know before making decision on either one. I've been working with clustering technology for many years by now, oracle, db2, a some Ms sql too. Specifically I'd be interested in practical failover time for both cases (assuming simple scenario 2 nodes active/active), maintenability, license cost etc... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
daimne
Starting Member
17 Posts |
Posted - 2008-10-14 : 16:06:36
|
| thanks. this helps!One question: when you don't have access to the application (to add failover to connect string..) and you need to set up mirroring for the database; what would you do? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 18:43:49
|
| Search for Application Failover in Database Mirroring .There is nice whitepaper regarding this. |
|
|
|
daimne
Starting Member
17 Posts |
Posted - 2008-10-17 : 18:33:46
|
| one way to set seemless failover by using: Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;" on the client site! if you have an access to it ;) |
|
|
|
|
Mirroring vs clustering, practical experience?