Clustering means to virtuallize multiple server in clustering term called node as a single server. SQL is a Cluster aware software. On Installing SQL server 2005 or 2008 it recognise the cluster environemnt and enables to install failover on clustering inside SQL Server Setup.
Sql Cluster installation is easy if the windows cluster configuration is good the set will install server server into all the nodes.
In SQL server 2005 when installation Starts in a cluster environment you will get the option to check failover cluster
then it will ask for the cluster name and you will require two provide 2 ip
1 private IP
2. Public IP
Hardware require for Clustering.
More that one same configuration server.
Share disk storage space like SAN.
Multiple LAN ports.
Server Drivers should also needs to be same else might through error. To troobleshoot clustering is bit difficult. Any standard OS required .e.g win 2003, 2008 R2 server are good cluster aware os.
Sql Cluster installation is easy if the windows cluster configuration is good the set will install server server into all the nodes.
In SQL server 2005 when installation Starts in a cluster environment you will get the option to check failover cluster
then it will ask for the cluster name and you will require two provide 2 ip
1 private IP
2. Public IP
Hardware require for Clustering.
More that one same configuration server.
Share disk storage space like SAN.
Multiple LAN ports.
Server Drivers should also needs to be same else might through error. To troobleshoot clustering is bit difficult. Any standard OS required .e.g win 2003, 2008 R2 server are good cluster aware os.
It is a good tutorial for creating SQL clustering. I am new to SQL clustering so would like to know more about it. Thanks and looking forward for some more knowledge and information.
ReplyDeleteSure Just to give a introduction over sql cluster you need to clear your basic like . We generally configure cluster in windows server for e.g. windows 2003 or 2008 and on it we install a cluster aware software ..
Deletelike SQL Server 2005 /2008 or denali..
We the evolution of the product there has also some change came with the confihuring of sql cluster ..
SQL server day by day becoming a very huge software product.
ReplyDelete