| Author |
Topic |
|
reoaran
Starting Member
20 Posts |
 Posted - 2010-08-02 : 14:26:20
|
| Hi,We are planning to install a SQL cluster in the VM and planning to have these set up of cluster in VM across the datacenter that is located in different sites which is of around 100+ miles range. I think this is not as straight installing as setting up the cluster within the same datacenter and hence would need some suggestions... I have some queries below for installing the cluster in the VM across different datacenter,1. Can we install cluster in the VM that is located in different sites?2. If we failover, how much time would it take to recover the database, application ?3. Is there any specifications that needs to be done from storage side?How does the quorum and shared drives work in this case?4. Any manual work would be needed ?5. Any other specifications do we need to consider apart from the normal cluster withing datacenter (like storage\ networks..)? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-02 : 14:58:05
|
quote:
Originally posted by reoaran
I think this is not as straight installing as setting up the cluster within the same datacenter
You are correct. You're asking about a geographically dispersed failover cluster, which has additional requirements and restrictions. SQL Server Books Online has details, there's also this:http://support.microsoft.com/kb/280743You should also check out this site:http://msmvps.com/blogs/jtoner/You may want to contact Microsoft and see if they can help, or refer someone who has experience setting these up. Adding VM to the mix may not be feasible or reliable enough for your needs. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-03 : 02:35:41
|
| May I ask how you came to the conclusion that a geographically dispersed cluster is the best way to go? If you get it to work in the first place it sounds like a continuous headache...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-17 : 15:49:14
|
| looks like it would be fun to set one up!--------------------keeping it simple... |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-17 : 16:11:21
|
quote:
And I don't think your notion of a few days inspection's going to wash either.In order to be of any value, you'd have to tear it apart.The metallurgy would take a couple of months.Then we'd have to keep it.What will you do with the crew?Ones that don't defect will go back and say we got the boat. Or do you plan to eliminate them?We're not at war, sir.So you have to get them off the boat in such a way that they think we don't have it, and they'll report that we don't have it to their bosses.Otherwise, this whole business is just academic, right?
Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-17 : 21:15:59
|
A geographically dispersed replication scheme makes a lot more sense.10 points to whoever knows what movie Brett is quoting this time  |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-18 : 07:03:57
|
quote:
10 points to whoever knows what movie Brett is quoting this time
It's the movie that's been playing on cable 3 times a day for the past 2 weeks.  The one with the Russian submarine. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-18 : 10:08:13
|
quote:
Originally posted by robvolk
quote:
10 points to whoever knows what movie Brett is quoting this time
It's the movie that's been playing on cable 3 times a day for the past 2 weeks. The one with the Russian submarine.
I don't have able..pure Antenna and Netflix on a WiFi RouterAnd it's one of my all time favorite movies...When Russian's had Scottish Accents, and Hollywood Celeb's hadn't deep sixed their careers (only to be miracolusly reurectted)Crank that Movie up in surround sound....you can hear the whales"There be Whales, captain..."..different movie...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-18 : 10:39:48
|
quote:
"There be Whales, captain..."..different movie...
Hellooooooooo, Computer!The keyboard! How quaint. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-18 : 10:56:25
|
quote:
Originally posted by robvolk
quote:
"There be Whales, captain..."..different movie...
Hellooooooooo, Computer!The keyboard! How quaint.
WOW...a bigger Geek than I thought ( Also, Dude, Geek is not the preferred nomenclature. Technologist-American, please.)Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
SQL Cluster in VM across different sites