January 21, 2014 at 10:31 am
Hi,
One of our client want to go for Sql cluster from standlone server and he want the answers for the below two questions.
1)What type of hard disks are used in the SQL cluster and how are they configured (RAID etc)?
2) How are the application host and SQL cluster connected?
Can any one help me to get this answers.Advance thanks.
January 21, 2014 at 11:04 am
Typically, you use either shared storage in the form of a Direct Attached Storage device, or a SAN for disks. RAiD levels are up to them (and their budget).
The Always On feature does allow for local disks to be used, so be sure to check on what they really want.
The applications will connect to a new network name that will be owned by one of the nodes of the cluster. This network name (and underlying IP address) can be flipped from one node to another in the cluster.
January 21, 2014 at 11:18 am
Thanks Matt Crowley for reply,
What i understood from your reply that
sql is not listen on ip address of both nodes but listens on virtual Sql ip address and virtual SQL cluster name and
when users connect to cluster,users will be connect to virtual sql name and sql ip address instead of node name or ip address.
January 21, 2014 at 11:35 am
bala2 (1/21/2014)
sql is not listen on ip address of both nodes but listens on virtual Sql ip address and virtual SQL cluster name
Not exactly, and you have to remember you're talking instances listening, not just the SQL Server listener. To get more more clarity on that look into active/active clusters vs. active/passive clusters. There's a LOT to clustering that's difficult to quickly express.
However, from a high level view and not getting too deep into the process, yes, generically that's correct.
and
when users connect to cluster,users will be connect to virtual sql name and sql ip address instead of node name or ip address.
Correct. The only people who should need to know the node addresses to the clusters are the DBAs and Sysadmins for when they have to do manual failovers for maintenance reasons.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply