To attempt to make this major task just a little easier, this article is divided into these, step-by-step sections:. Each of the above steps must be completed in the above order before you can begin to use SQL Server clustering in a production environment.
It is assumed that the reader of this article has a good understanding of how to install, configure, and manage Windows and SQL Server It also assumes that the reader is a local administrator of the servers on which SQL Server clustering will be installed. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox.
Newsletter Topics Select minimum 1 topic. Any thoughts? Anonymous Posted July 10, 0 Comments. A cluster uses Named pipes, did you enable the protocol?
By default, all the drives will be selected but if you wish to add more or remove some drives you can highlight the drives and click Add or Remove. Specify your quorum drive. The Quorum drive holds log files and health information about your cluster. If one node fails, the surviving node depends on the quorum drive to start the services. For simplicity, I always call my quorum drive the Q drive. It should be about MB in size typically, although much of that space will go unused.
After selecting the drive, click Next. Read the message about the types of networks that can be configured and click Next. I prefer to have the heartbeat connection over a private network for security and everything else go over the public network.
You will be presented a screen to configure each network connection. To use the each network connection, click the Enable This Network For Cluster Use and then select the type of use it will have. For example, if you want all traffic to go out on a single network card, select All Communication mixed network.
If you only configure you cluster for one connection, you will receive a warning stating that you now have a single-point of failure. Acknowledge the warning to proceed.
You will also need to specify the subnet for the IP address and which connection will be used by clients to connect to the cluster. Not too bad, is it? Now click Finish to complete the wizard and acknowledge that the service was successfully started.
No reboot is required after installing a cluster. This time select the Second Node option as shown in Step 5. By selecting that option and specifying a security account for Windows to use, the wizard will read the configuration from the first node and almost automatically configure itself.
Goal 2 — Configure the Cluster By installing the cluster on both nodes, you have also created a new tool called the Cluster Administrator.
With this tool, you can configure your cluster for optimal use. You can run the tool like you do most other tools in Windows , by going to Control Panel and selecting Administrative Tools. By default, each shared disk you assigned earlier resides in its own group under Groups.
I prefer to keep similar resources together. With that in mind, I create two new groups: Server1 and Server2. I then place the drives from each independent group into one of the two groups. Leave this group alone. In Cluster Administrator, if you get lost, right-click. For example to move the drive to one of the two groups right click on the resource and click Move to New Group. Once you have all the drives except the quorum drive moved to one of the two new groups, delete the empty groups.
You can then test a failover by right clicking on the group and selecting Move Group. You will then see the resources fail, go to Online Pending, then to Online on the new server.
You may also want to configure the primary owner of each drive. You can do this by right-clicking on the resource and clicking Properties. Which group you place your resources in is very important. A resource can only act as a dependent on another resource that is in the same cluster group. In installing SQL Server there are only a few additional steps that you may not be used to. Before we begin, make sure each of your nodes is online.
To install the clustered version of MS DTC, go to a command line and type comclust it will be in your path. This resource is located in the Cluster Group in Cluster Administrator.
Perform the same action on the any other nodes in the cluster as well. Start installing SQL Server as you would normally.
You now have an added option of a Virtual Server. After you step through the license agreement, you will be asked to specify an IP address and subnet for your virtual SQL Server name.
Type the virtual IP address and the subnet will automatically fill itself in for you.
0コメント