کد:
http://itprosecure.com/blogs/windows_2008_admnistration/archive/2009/08/03/windows-2008-failover-clustering-configuring-sql-2008-for-failover-clustering-part-3-of-3.aspx
PART-3
First, I will build the Windows 2008 Failover Cluster using 3 Nodes and a Node Majority for the Quorum Configuration. Here is that completed work.
Figure A - 3 Node Windows 2008 Failover Cluster. This is built in Blog Part 1 and 2.
Then I will build the Application Cluster running Windows 2008 Failover Clustering and SQL 2008 Failover Clustering Services.
Figure B - 3 Node Windows 2008 Failover Cluster with SQL 2008 Failover Cluster across all Nodes. This is built in Blog Part 3.
************************************************** *************************
************************************************** *************************
Figure 1 - As I get underway to install the SQL 2008 Failover Clustering configuration on the first Cluster Node (b01-node-1) I validate the available LUNs for Storage. There are 3 each 40GB LUNs (Drive L:\, M:\, N:\) with 1 each 1.4GB LUN set aside for a Quorum Drive (Q:\). We will target the SQL 2008 Services to the L:\, M:\ and N:\ Drive.
Figure 2 - I begin the SQL 2008 Failover Cluster Installation using the SQL 2008 x64 Enterprise Edition Media and selecting 'System Configuration Checker' to validate I did not overlook any additional requirements for Installation.
Figure 3 - The 'System Configuration Checker' provides feedback that 14 of 14 Operations completed successfully. I proceed with the Installation Steps.
Figure 4 - I select 'Installation' from the 'SQL Server Installation Center' and then, 'New SQL Server Failover Cluster Installation'.
Figure 5 - The 'SQL Server 2008 Setup Support Rules' indicate passing on 6 of 6 Rules evaluated as part of proceeding with Installation.
Figure 6 - Advancement to Acceptance of a Product Key indicates forward progress.
Figure 7 - In the 'License Terms' dialogue windows I mark the Check Box to 'Accept the License Terms' to proceed with the Installation.
Figure 8 - The 'Setup Support Files' status simply requires pressing the 'Install Button' to proceed.
Figure 9 - An additional list from the 'Setup Support Rules' indicates passing on 28 Operations with Warning received on 2 Operations. Research of the 2 Operations offering Warning indicate acceptability to proceed with the Installation.
Figure 10 - I double check the 2 'Operations' offering 'Warnings'. The 'Network Binding Order' and 'Windows Firewall' require additional research to confirm the specifics the 'Operation' requires. I double-checked the 'Network Binding Order' to confirm it is correct, while the 'Windows Firewall' is offering a 'Warning' simply due to a Group Policy Object 'Disabling' the Windows Firewall for the Cluster Nodes.
Figure 11 - I proceed past the 'Setup Support Rules' dialogue window and begin selecting parameters for the SQL 2008 Failover Clustering Services.
Figure 12 - In the 'Feature Selection' window for 'Install a SQL Server Failover Cluster' I select a number of 'Features'. The requirements for your Application will define the 'Features' required. Keep in mind there are special configuration steps for Features which do not Cluster, like Reporting Services.
Figure 13 - In the 'Instance Configuration' dialogue windows I input 'app-db-01' as the 'SQL Server Network Name' to proceed.
Figure 14 - In the 'Disk Space Requirements' dialogue window is the Summary of the Installation Requirements configured so far. I proceed to define the 'Cluster Resource Group' parameters next.
Figure 15 - SQL 2008 'identifies' the 'Resource Group Names' currently associated with the Cluster (these are, 'app-cluster-dtc', 'Available Storage' and 'Cluster Group'). The default name of 'SQL Server (MSSQLSSERVER)' is offered as a Resource Group Name for Clustered SQL 2008. I accept this default value and proceed.
Figure 16 - The 'Install a SQL Server Failover Cluster Wizard' advances to the 'Cluster Disk Selection' dialogue window. The Wizard defaults to the uppermost Disk available (in this case, L:\) where I add both M:\ and N:\ as well.
Figure 17 - The values for 'Cluster Network Configuration' default to 'IPv4' and 'DHCP'. I modified the default values by 'toggling off' DHCP and inputting an 'Address' and 'Subnet Mask' of '192.168.1.67' and '255.255.255.0'.
Figure 18 - In Part 2 of this Blog entry we created a number of Domain User IDs to consumption by SQL 2008. On the 'Service Accounts' Tab of the 'Server Configuration' dialogue window I input these unique User IDs for 1) SQL Server Agent, 2) SQL Server Database Engine, and 3) SQL Server Reporting Services.
Figure 19 - The 'Database Engine Configuration' dialogue window provides the ability to define 'SQL Server Administrators'. The DGSG added earlier to Active Directory titled 'app-db-01 SQL Full Admins' is 'Added' as a SQL Server Administrator.
Figure 20 - Next, I configure the 'Database Engine Configuration' by associating the appropriate Directory with a unique LUN (Disk Drive).
Figure 21 - The 'Reporting Services Configuration' dialogue window only offers the option to 'Install, but do not configure the report server' for a Clustered Configuration. Additional details regarding Reporting Service on a SQL 2008 Failover Cluster can be identified in the MSDN Documentation.
Figure 22 - The 'Error and Usage Reporting' dialogue window offers an automated capacity to provide information to Microsoft for Product improvements.
Figure 23 - The 'Cluster Installation Rules' validate passing 7 of 8 Operations with 1 of 8 being 'Not Applicable'. This steps takes us to the corner of the initial Installation of SQL 2008 Failover Clustering on a Windows 2008 Failover Cluster.
Figure 24 - The 'Ready to Install' dialogue window provides an important output file - the 'Configurationfile.ini', that records this configuration parameters. This .ini File can be used as the 'template' for Node 2 and Node 3 if appropriate.
Figure 25 - Upon successful Installation the 'Install a SQL Server Failover Cluster Wizard' will provide a detailed output Text file regarding the Installation Process, Parameters and Actions. I am now ready to move from Node 1 (b01-node-1) to Node 2 (b01-node-2) for the SQL 2008 Failover Cluster Installation. The modified version of these steps occurs on Node 2 and Node 3 to ensure participation in the SQl 2008 Failover Cluster Installation.
Figure 26 - Upon moving to Node 2 (b01-node-2) I initiate the SQL 2008 Failover Cluster Installation process. Again, this is a modified (i.e. reduced number of steps) version of the previous SQL 2008 Failover Cluster Installation.
Figure 27 - Instead of selecting 'New SQL Server Failover Cluster Installation' from the 'SQL Server Installation Center', I select 'Add a Node to a SQL Server Failover Cluster' instead.
Figure 28 - The 'SQL Server 2008 Setup' understand the available Cluster Groups and Cluster Resources as the Installation process begins. The 6 Operations performed for the 'Setup Support Rules' pass with Success.
Figure 29 - Notice the immediate advancement all the way to the 'Product Key' dialogue window when adding a second SQL 2008 Failover Cluster Node. In the initial SQL 2008 Failover Cluster Node Installation, this step is quite a few screens into the Installation process.
Figure 30 - Acceptance of the 'License Terms' occurs next in the 'SQL Server 2008 Setup Wizard'. I 'Accept' and proceed.
Figure 31 - The 'Setup Support Files' dialogue windows requires input of the 'Install Button' to proceed.
Figure 32 - The additional 'Setup Support Rules' triggered as part of this Installation process identify the same 2 'Warnings' (Network Binding Order and Windows Firewall) as the initial SQL 2008 Failover Cluster Node Installation. I proceed with the Installation understanding further research is required for both of these 'Warnings'.
Figure 33 - In the 'Cluster Node Configuration' dialogue windows the SQL 2008 Failover Cluster Installation 'associates' with the existing SQL Instance of 'MSSQLSERVER' on 'app-db-01'. I proceed to confirm additional of another Node to support this Instance.
Figure 34 - Input of Passwords for the 'Service Accounts' for the specific SQL 2008 Failover Cluster Services provides validation of this Node to the Cluster to run SQL Failover Cluster Services.
Figure 35 - The 'Error and Usage Reporting' dialogue window provides the options for automating Feedback to Microsoft regarding SQL 2008.
Figure 36 - The 'Add Node Rules' perform some of the final 'confirmations' prior to adding another Node to this SQL 2008 Failover Cluster configuration. I am working here on Node 2, but the exact same steps apply to the addition of Node 3.
Figure 37 - The 'Ready to Add Node' dialogue windows again points us to the 'ConfigurationFile.ini' and the beginning of the Installation process.
Figure 38 - Here is a successful completion of adding another Node running SQL 2008 Failover Cluster Services to a Windows 2008 Failover Cluster. This process is repeated for Node 3 in this configuration following the exact same steps as outlined in this Blog entry (Part 3 of 3). The result, a 3 Node SQL Failover Cluster ready for further configuration by Application type!
Figure 39 - Finally, let's examine the output of following the numerous configuration steps for this environment. The 'Failover Cluster Management' MMC shows a new Application Server named 'app-db-01.corp.itpslab.local', with 3 Volumes (LUNs) supporting its Sevices (L:\, M:\ and N:\) supported across 3 Windows 2008 Failover Cluster Nodes (b01-node-1, b01-node-2 and b01-node-3). A separate Clustered Distributed Transaction Coordinate (DTC) also is available as part of this configuration.
Summary: In this Blog entry, the third of three, I follow step-by-step procedures to SQL 2008 Failover Clustering Services. This 3 Node Cluster running on Windows 2008 Failover Clustering is an example of a configuration designed to support 'Cluster Aware Applications' on Windows 2008