Archive

Posts Tagged ‘SQL server’

Types of Clusters and Steps to Set-up MS-SQL Web Server Cluster.

August 3rd, 2009 No comments

Cluster is usually useful to reduce the load on a particular server.

Basically, clustering can be defined as the use of more than one computer/ server that can work together. In this type of architecture, multiple servers are liked to one another and has the capability of handling workloads. It helps to offer continued working and offer 100% uptime. All the machines in a cluster are involved in the operations at any given point of time. The cluster of servers offer fault tolerance. It is also termed as Load Balancing.

There are two types of clustering architectures offered by Web Hosting services providers.

A) Failover Cluster Server:

Multiple servers are involved in Failover Cluster. Failover clustering is different from Load Balancing servers. The term itself gives a little hint of what it is. Servers are placed in a cluster to offer high availability, though there is an hardware or software failure. If a hardware or software fails, a counter action is taken by the cluster itself and the resources are fetched from other servers to continue with the operations. There is a constant monitoring always active in the cluster to monitor the resources. A practical failover of software as well as hardware including the current status of applications can be achieved by fault tolerant fail over cluster.

Below is a pictoral description of Failover Cluster Server.

Failover Clustered Server

B) Web Server Load Balancing:

The basic intention of a load balancing architecture is to distribute the load among the servers in the cluster. A cluster can have more than one servers. You can keep adding servers to the cluster. These servers are set up in such a way that the traffic is distributed Load Balanced Serveramong all the servers. Its due to such an architecture that the network load gets re-distributed and is not focused on a single server. This helps in offering better reliability and gaining much improved performance.

There are common set of hardware that is required which is two server nodes in the cluster. Both the servers are connected to the network, both having their individual operating systems. Among the nodes, only one node is kept active at a given point of time. This is also termed as the “Active/Passive” solution. The resources of the cluster is utilized by the active server or the node and the data is written onto Shared Disks. Just incase if a node fails, the other node takes its place. To check if all the nodes are working properly, a signal known as ‘Heartbeat’ is sent across the network of the servers. If the active server fails to respond, the passive server gets triggered and starts functioning as an active server. The resources of the cluster are diverted to the passive server which is operating as the main active server.

Below are the Steps to Install a SQL Server in a cluster

It is important that the cluster is operational before you Install a SQL Server into the cluster.

a) You require Windows Server edition with a support to MSCS on every server.

b) One must get assured about every server in the cluster to be connected to the private network.

c) You must set up a different network and mind that you do not connect them to this network, it must only be used for sending the heartbeat signals.

d) You need to create a user account for the service accounts for the cluster to operate under this account in the domain. You also need to add every administrators group of every server.

e) Now you can connect the shared hard disks to the server then shut the servers off and switch on the node number one of the cluster.

f) Now you can install Microsoft Cluster and then configure it through the control panel.

g) Now, you must provide a name to the cluster and assign an IP address with the resources of the Shared Disk.

h) After all the above mentioned steps are followed, now you must turn ON the second node in the cluster and move to the Fist node, only when the second comes online.

This concludes the set-up of the cluster. You can refer the below guidelines to Install SQL server in the cluster.

a) You need to insert the CD SQL Server Enterprize edition, you may or may not have to do the installation manually.

b) Now you can choose the Virtual Server on the on the computer name screen and enter the name that you wish to have the Clustered referred as.

c) You need to now create a service account to run SQL web server that you provide administration rights on each node on the cluster.

d) You can allocate an IP address, Shared Resources and a service account to the SQL Server at the time of installation.

Misconceptions about Linux Web Hosting.

May 24th, 2009 No comments

Some people are yet confused and aren’t sure about the Operating System (OS) to be installed on their servers. Let me clear that doubt, one can have any OS on a server, irrespective of the one they have on their local computing machine. It makes no difference if one has Windows on the local machine and wishes to have Linux OS on the server.

Windows-Hosting-LogoLinux-LogoAs we all are aware, Windows and Linux are two different operating systems. Windows is widely used on the household/office PC’s. Linux is a newer version of Unix OS. Both contribute to an excellent web hosting environment. Though, we cannot deny the Pro’s and Con’s of each.

An individual usually gets stuck when choosing the OS on the servers. Here are certain factors that may help you to get rid of this confusion.

COST:

Cost is one of the major determining factors when choosing an OS.

Linux is an Open Source OS, which means one does not need to pay the licensing fees inorder to have it. Hence, Linux is comparatively cheaper than Windows. Whereas, one needs to purchase the license of Windows inorder to install it on the machine. A single licensed copy can be installed on one computer. But, with Linux, once you own it, you can freely install it on any number of machines.

RELIABILITY:

Linux is reputed for its stability and reliability. Meaning, Linux server is much less likely to crash than Windows Server. Hence, these servers can offer more uptime to the web-sites hosted on it.

SPEED:

There is practically not much difference in the speed of both the OS, but there is marginally faster speed seen in Linux when processing basic web pages.

Perl_LogoSCRIPTS:

Many CGI programs can be found over the Internet. Majority of the Perl scripts, developed on Unix/Linux servers.Most of them can be freely downloaded from the internet.

FUNCTIONALITY:

Microsoft’s Active Server Pages (ASP) programming/scripting language Active-Server-Pagesare supported by Windows only. It enables oneself to build dynamic web-pages by connecting to Microsoft’s database such as SQL server or Access. Linux, does not offer any support to ASP and Microsoft databases, instead MySQL database is supported.

Today, more and more people are switching to Linux Web Hosting solutions as it is easy to use, more stable, open source, free updates are available and most importantly it is cheap. Hence, unless ASP and MsSQL database is required by a web site, Linux can prove to be a better choice over Windows.

 
 

Need Help ?

-- Client Area
-- Sitemap
-- Help Center
-- Tutorials

Resources

-- Web Hosting Forum
-- Web Hosting Blog
-- Knowledgebase

Partners

-- Affiliate program

Legal Information

-- Terms of Service
-- Service Level Agreement
-- Privacy Policy

Toll Free : 866 662 0909
1.213.255.7012 &
1.302.294.5628