clustering

  • Iam doing clusteing now,So how to know the virtual ip addresses of the two physical machines that we are going to cluster?

    thanx

  • you should ask your Windows Admin. they are supposed to provide you this.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • The virtual IP used should be provided by the sys admins. Tell them you need at least one IP for each NIC of the SQL Server, don't forget about the heartbeat NIC. Once your physical boxes are configured, you will need a IP for the SQL server which they should also provide.

    Remember, you just set up your cluster and assign resources prior to installing SQL server. Make sure your Quorum drive is sufficient and is not shared with anything else.

    In other words, at a minimum, you need 5 ip addresses, I can dig up an old white paper if you want, just let me know if you have any questions

    Marvin Dillard
    Senior Consultant
    Claraview Inc

  • Thanx marvin,It would be helpful if you provide me the old white paper and if possible provide any screen shots.

  • Connect the shared storage buses and assign drive letters

    Updated: January 21, 2005

    To connect the shared storage buses and assign drive letters

    1.

    Install Windows Server 2003, Enterprise Edition or Windows Server 2003, Datacenter Edition on all nodes.

    Caution

    All nodes in a cluster must be running the same version of the operating system, that is, either Windows Server 2003, Enterprise Edition or Windows Server 2003, Datacenter Edition. You cannot run both Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition on nodes in the same cluster.

    2.

    Prepare the controllers for the shared storage bus, following the instructions in your storage bus owner's manual.

    3.

    Install the controllers for the shared storage bus, but do not connect them to the shared storage bus.

    4.

    Connect the shared storage devices to the shared buses, and then connect the shared storage buses to all nodes.

    5.

    Start the operating system on the first node on which you intend to create the cluster.

    6.

    Format the disks on the cluster storage device as NTFS.

    For more information, see "To format a basic volume" in Related Topics.

    Caution

    Each disk on the cluster storage device must be a basic disk, not a dynamic disk.

    7.

    Partition the disks on the cluster storage device.

    For more information, see "To create a partition or logical drive" in Related Topics.

    8.

    Do one of the following:

    Assign drive letters to the disks on the cluster storage device.

    Assign mount points to the disks on the cluster storage device.

    For more information, see "To assign, change, or remove a drive letter" and "To create a mounted drive" in Related Topics.

    Caution

    Make sure that you create unique mounted drives so that they do not conflict with existing local drives on any node in the cluster.

    Do not create mounted drives between disks on the cluster storage device (cluster disks) and local disks.

    Do not create a mounted drive from a clustered disk to the cluster disk that contains the quorum resource (the quorum disk). You can, however, create a mounted drive from the quorum disk to a clustered disk.

    Mounted drives from one cluster disk to another must be in the same cluster resource group, and must be dependent on the root disk.

    9.

    Label all partitions to match their drive letters or mount points assigned in the step above.

    10.

    Use Cluster Administrator to add the first node to the cluster.

    For more information, see "To add the first node to the cluster" in Related Topics.

    Caution

    Completely create the cluster on one node before you join additional nodes to the cluster.

    Important

    When you create a cluster, Physical Disk resources will be automatically created for cluster disks that use drive letters. However, if your cluster disks use mount points, Physical Disk resources will not be automatically created for those disks; you must manually create disk resources for cluster disks that use mount points. For more information on how to do this, see "Checklist: Installing a Physical Disk resource" in Related Topics.

    11.

    Join one or more additional nodes to the cluster.

    For more information, see "To add additional nodes to the cluster" in Related Topics.

    Top of page

    Information about functional differences

    Your server might function differently based on the version and edition of the operating system that is installed, your account permissions, and your menu settings. For more information, see Viewing Help on the Web .

    Marvin Dillard
    Senior Consultant
    Claraview Inc

  • There is also a very good video at the following link. B Knight is one of the founders of this site and is well known in the SQL Server community.

    http://www.jumpstarttv.com/Media.aspx?vid=33

    Marvin Dillard
    Senior Consultant
    Claraview Inc

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply