Recent projects need to set up a Cluster service for SQL Server, multiple SQL Server databases to set up cluster services, and provide a unique URL access address. When the primary node loses power and the network is disconnected, the message is passed to the standby node through the heartbeat line. The standby node takes over the database access task within 3 seconds. Realize the dual-machine hot standby.
Because the desktop has been in place for 2 days. So the first 2 sets of Windows Server R2 systems are installed on the virtual machine to simulate the cluster creation process. An article about SQL Server cluster creation. There are divergent opinions on the Internet. For a novice, can be overwhelmed. However, the creation of the quorum disk and the shared disk in the cluster is necessary for each cluster, where I put the virtual machine cluster quorum disk and the data sharing disk creation process and share with you, hoping to help everyone.
1. Create a directory sharediskson your local computer. For example I am: The D:\sharedisks,sharedisks directory is used to save the virtual quorum disk and data shared disk files created by the next two operations.
2. Create the quorum disk. In the Dos form, enter the VMware Workstation Software installation folder, for example, my installation folder is: E:\VM. In the Dos form, enter for example the following command: Vmware-vdiskmanager.exe-c-S 500mb-a lsilogic-t 4 "D:\ShareDisks" \QUORUM.VMDK.
For example, the following:
3. Create a data-sharing disk. entering VMware in a DOS form Workstation Software Installation folder, for example, my installation folder is: E:\VM. In the Dos form, enter for example the following command:vmware-vdiskmanager.exe-c-S 1gb-a lsilogic-t 4 "D:\ShareDisks" \SHAREDISK.VMDK. For example, the following:
4. Verify that the shared disk was created successfully, open the Sharedisks directory under D, for example, the following:
5. The attachment quorum disk and the data share disk to the virtual machine. Locate the corresponding Virtual system installation folder for Node 1 (not the virtual Machine Software installation folder), for example I am E:\VM\Server2008R2-A, find the *.vmx (VMware Config file), open with Notepad, add such as the following record:
For example, the following:
6. Restart the VMware Workstation for an effect that proves the creation was successful.
7. Mounting a new disk to a virtual machine system may cause the system to reverse the order of the boot disks.
Assuming that the system can start normally before mounting, the "pxe-mof:exiting Intel PXE ROM operating system not found" error appears after mounting, You need to set the boot disk of the system again in the virtual machine BIOS. Operation steps: In step 5 found in the *.vmx file appended bios.forcesetuponce = "TRUE", so that the boot system into the BIOS page. Setting the system boot disk again in the boot of the BIOS will start the system normally.
This explains the creation process for the VMware Workstation cluster quorum disk and the data-sharing disk.
Just a virtual machine is a virtual machine. There are many places that cannot be imitated.
When the desktop is up, the concealing of the various clusters are available. I started experimenting on the real thing to the desktop.
I hope you can pay attention to my blog about the creation of clusters, thank you.
VMware Workstation cluster quorum disk and data-sharing disk creation