Nlb+sql High availability for corporate business servers in virtualized environments (i)

I. Background of the project

The company has 5 servers hosted in the ISP Center, of which 3 dell720,2 DELL910, escrow fee is 78,000 yuan/year. The load on each server is very low, and the company has a mandatory copyright requirement for the software and does not allow the use of pirated software. VMware5.5 version, each physical host only allow 1 CPU free to use, the newly released VMware6.0 canceled the limit, as long as the number of logical CPUs on each physical machine not more than 480, in its internal logical CPU per virtual machine not more than 8, you can apply for free. So there is the idea of concentrating all the servers on the 1 platform.

Second, the preparation of the preparatory

Before migrating, you need to collect the load of each physical host at this stage, primarily CPU, memory, and hard disk usage, in order to estimate the minimum configuration required for these 1 physical machines in the future. Memory and hard drives can be seen directly from the task manager, so here's a focus on CPU load calculation methods. The CPU load calculation method is:

CPU minimum configuration =CPU Master Frequency * Number * utilization

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/52/wKioL1XLRtPCXtX5AAQlpWklZtg434.jpg "title=" 10.jpg "alt=" Wkiol1xlrtpcxtx5aaqlpwklztg434.jpg "/>

For example, the current CPU frequency is 2.5G, so the minimum requirement for the CPU after migration is: 2.5*8*8%=1.6g.

Third, design ideas

Considering the server fault tolerance and the single point of failure of the network, the following structure is designed:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/56/wKiom1XLWXXQpRVVAAIHkuDnNPs799.jpg "title=" 1.png " alt= "Wkiom1xlwxxqprvvaaihkudnnps799.jpg"/>

Purple background for the installation of VMware6.0 physical host, the network card 1, 2 as the Management network card, the address is 10.0.0.7/24; Nic 3, 4 as the production network card, set up a virtual switch. Front-end 2 Web servers do NLB load balancing and fault tolerance, back-end 3 servers do SQL mirroring high availability (there is no shared storage in the actual production environment, so high availability of SQL is not possible with cluster), and NLB and SQL mirroring are highly available in workgroup environment, in order to facilitate post-management, so or in a domain environment to build. It is important to note that the address of ESXi, although 10.0.0.7/24 and other virtual host is the same as 10.0.0.0/24 network segment, but not the same LAN, so there is no ping between each other. The server address of the production network is 10.0.0.2/24--10.0.0.6/24, the gateway is the address of the firewall 10.0.0.1/24, the latter is built in the experimental environment, the firewall factor is not considered, so the server address is 10.0.0.1/24--10.0.0.5 /24, the gateway is empty, in this special note.

Iv. Cost additional Budget

The company currently has 4 sets of WINDOWSSERVER2008R2 Enterprise Edition and 2 sets of SQLSERVER2008R2, in which SQL Server on the witness servers can use Microsoft Free Express Edition, So we need to buy another set of WINDOWSSERVER2008R2.

Five, the Operation procedure

This chapter focuses on the application of NLB and SQL high availability in a virtual environment, so installing ESXi and building a domain environment is not a good practice. The corresponding IP address for server 08SERVER1--08SERVER5 is 10.0.0.1/24--10.0.0.5/24.

1. Installing the NLB Service

1) Locate and install the IIS service in the 08server1 and 08server2 server roles.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/57/wKiom1XLYseBl6B0AAKGdBmEbMw130.jpg "title=" 11.jpg "alt=" Wkiom1xlysebl6b0aakgdbmebmw130.jpg "/>

2) Create a website on 08server1 and 08server2, and place index.htm in 1th place.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/71/53/wKioL1XLZOrzPRdkAAI8jcP09F0367.jpg "style=" float: none; "title=" 13.jpg "alt=" Wkiol1xlzorzprdkaai8jcp09f0367.jpg "/>

3) Create a index.htm folder in the root directory of the 08server1 and 08serve2, respectively, to make the 08server1 content welcome to the convenience of the latter. Contoso1.com,08serve2 content is written into Welcome to contoso2.com.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/71/57/wKiom1XLYueR3yhKAAHy3VtdpBk939.jpg "style=" float: none; "title=" 14.jpg "alt=" Wkiom1xlyuer3yhkaahy3vtdpbk939.jpg "/>

4) Locate and install Network Load Balancing in the 08server1 feature.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/57/wKiom1XLYubwFZiGAAKffG-EFMQ846.jpg "title=" 12.jpg "Style=" Float:none; "alt=" wkiom1xlyubwfzigaakffg-efmq846.jpg "/>

5) Open Network and load Balancing Manager.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/53/wKioL1XLZOvzK6GEAAEBUpPrsIU164.jpg "style=" float: none; "title=" 15.jpg "alt=" Wkiol1xlzovzk6geaaebupprsiu164.jpg "/>

6) Create a new NLB cluster, which you need to be aware of: After you have built the cluster, add the member server.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/57/wKiom1XLYuixNMujAAIKrgxqYcI683.jpg "style=" float: none; "title=" 16.jpg "alt=" Wkiom1xlyuixnmujaaikrgxqyci683.jpg "/>

7) Configure an IP address for the NLB cluster, which provides a unified service to the server in the cluster by proportionally splitting the received request link.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/53/wKioL1XLZOyirG7ZAAIFyXttw-w222.jpg "style=" float: none; "title=" 17.jpg "alt=" Wkiol1xlzoyirg7zaaifyxttw-w222.jpg "/>

8) Set the FQDN name of the NLB cluster, select the group and operation mode. Note : If the server that joins the cluster has only one NIC, be sure to select multicast mode.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/57/wKiom1XLYuria3L7AAIEmjKIV5k167.jpg "style=" float: none; "title=" 18.jpg "alt=" Wkiom1xlyuria3l7aaiemjkiv5k167.jpg "/>

9) Pending status becomes aggregated, the NLB cluster was created successfully.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/71/53/wKioL1XLZO7BsA18AAKcZn81cQM416.jpg "style=" float: none; "title=" 19.jpg "alt=" Wkiol1xlzo7bsa18aakczn81cqm416.jpg "/>

10) Add the 08server2 to the NLB cluster again.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/71/57/wKiom1XLYuyxJpEaAALR233i8JI313.jpg "style=" float: none; "title=" 20.jpg "alt=" Wkiom1xlyuyxjpeaaalr233i8ji313.jpg "/>

11) Once added successfully, the status will also become "aggregated".

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/53/wKioL1XLZPCBgUhhAAMOsjs1xDs276.jpg "style=" float: none; "title=" 21.jpg "alt=" Wkiol1xlzpcbguhhaamosjs1xds276.jpg "/>

12) The load balancing ratio can be set in the server port rules within the NLB cluster.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/71/57/wKiom1XLYu7D2ChzAAPib4j4Tkk348.jpg "style=" float: none; "title=" 22.jpg "alt=" Wkiom1xlyu7d2chzaapib4j4tkk348.jpg "/>

13) Find a Win7 computer, set the IP address to 10.0.0.100/24, point the www.contoso.com in the host file to the IP address that the NLB cluster provides for external service, and access the test in the browser. At this point we can see that it is connected to the 08server2 server.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/53/wKioL1XLZPKyVlBiAAJIIj4qja4907.jpg "style=" float: none; "title=" 23.jpg "alt=" Wkiol1xlzpkyvlbiaajiij4qja4907.jpg "/>

14) After you shut down the 08SERVER2 server and reconnect again, you can see that it has been redirected to the 08server1 server.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/53/wKioL1XLZPOQ_KilAAKWfYquGPQ681.jpg "style=" float: none; "title=" 25.jpg "alt=" Wkiol1xlzpoq_kilaakwfyqugpq681.jpg "/>

15) then shut down the 08server1 server and reconnect it to the 08server2 server.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/71/54/wKioL1XLaxvASQKsAAJIIj4qja4451.jpg "title=" 23.jpg "alt=" Wkiol1xlaxvasqksaajiij4qja4451.jpg "/>

Nlb+sql High availability for corporate business servers in virtualized environments (i)