SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL Cluster in VM across different sites
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

reoaran
Starting Member

India
20 Posts

Posted - 08/02/2010 :  14:26:20  Show Profile  Reply with Quote
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

USA
15688 Posts

Posted - 08/02/2010 :  14:58:05  Show Profile  Visit robvolk's Homepage  Reply with Quote
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/280743

You 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.
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 08/03/2010 :  02:35:41  Show Profile  Reply with Quote
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...

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37464 Posts

Posted - 08/03/2010 :  12:44:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
It is super expensive too.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 08/17/2010 :  15:49:14  Show Profile  Send jen a Yahoo! Message  Reply with Quote
looks like it would be fun to set one up!

--------------------
keeping it simple...
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/17/2010 :  16:11:21  Show Profile  Reply with Quote
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?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 08/17/2010 :  21:15:59  Show Profile  Visit russell's Homepage  Reply with Quote
A geographically dispersed replication scheme makes a lot more sense.

10 points to whoever knows what movie Brett is quoting this time

Edited by - russell on 08/17/2010 21:16:42
Go to Top of Page

robvolk
Most Valuable Yak

USA
15688 Posts

Posted - 08/18/2010 :  07:03:57  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/18/2010 :  10:08:13  Show Profile  Reply with Quote
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 Router

And 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...




Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

robvolk
Most Valuable Yak

USA
15688 Posts

Posted - 08/18/2010 :  10:39:48  Show Profile  Visit robvolk's Homepage  Reply with Quote
quote:
"There be Whales, captain..."

..different movie...
Hellooooooooo, Computer!

The keyboard! How quaint.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/18/2010 :  10:56:25  Show Profile  Reply with Quote
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.)



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000