Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

2 node active/active iscsi question

Active Directory, Domain, DNS, WINS, DHCP, SBS, New Releases.

2 node active/active iscsi question

Postby guest » Wed Dec 10, 2008 11:29 am

Comments inline


> I'm attempting to set up a 2 node active/active sql 2005 (ent edition)
> failover cluster with an HP 2000i MSA iscsi storage box. Server is 2003
> Ent
> Edition.
>
> At the hardware level on the 2000i, I've created 3 raid 10 virtual disks
> as
> follows:
> SqlData w/ 2 volumes, SqlData1 and SqlData2
> SqlLog w/ 2 volumes, SqlLog1 and SqlLog2
> SqlTempDB, w/ 3 volumes, Quorum, TempDB_DB01 and TempDB_02.
>
> The intent is for one active node to 'own' the SqlData1, SqlLog1, and
> TempDB_DB01 volumes and the other node would own SqlData2, SqlLog2, and
> Tempdb_02 - with the quorum volumne serving as the quorum.

Nodes do not "own" resources. Resource groups own resources. Resource
groups are virtual servers which are instances.

So you would have two SQL instances, each ownign a data, tempdb and log
resource.

Good

>
> It looks like at this same hardware level I can map these volumes to the
> physical db machines via luns.
>
> My first question is: Do I use the same lun number for mapping a volume to
> the physical host? i.e, when mapping SQlData1 to physical host sqldb01 I
> am
> using lun # 6 - when I map the same volume to physical host sqldb02 do I
> use
> lun # 6 again or does it need to be a different lun? I assume BOTH
> physical
> db nodes need to be mapped for failover to work.
>
You use the same LUN ID on both host servers. All resources must be mapped
to all nodes.

> Second question, similar to the first - on each host do the drive letters
> for these volumes need to be the same or should they be different? i.e.,
> continuing from teh example above I have the SqlData1 volume on physical
> host
> sqldb01 using drive letter 'Y' - would I use the *same* drive letter on
> physical host sqldb02 or should it be different?
>
The same drive letters get used on both hosts. The cluster service
arbitrates current ownership of the disk resource(s) so they follows the
resource group.


> Thanks in advance, I'm running out of time to get this going :)

Don't hurry too much. Doing over is always more expensive than doing it
right the first time.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com

Troubleshooting Vista Wireless
http://chicagotech.net/
guest
 
Posts: 10191
Joined: Mon Nov 27, 2006 1:10 pm

Return to Windows

Your Ad Here

Who is online

Users browsing this forum: Yahoo [Bot] and 7 guests