Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Please tell me some knowledge about Clustering and how to
add clustering?



Please tell me some knowledge about Clustering and how to add clustering?..

Answer / balakrishna

clustering is the consupt of high availability where min of
2 servers participate. here the data and the log files are
stored on network storage called to be as nas or san. there
will be a dedicated link between the servers participating
in clustering where the secondary server will be pinging the
primary server to check the heart beet of the primary.
the disks used for storing the resources are called to be
as Quorum disks.
there is a necessity of aver all 5 IP addresses for the
cluster. out of five IP addresses one is called to be as
cluster address and the clients connect to the
cluster/database through this address.
again there are two types of cluster
1. Active/Active cluster
2. Active/Passive cluster. u can see more details of this
on the net

when we come to active/passive cluster the secondary node
continuously check the heart beet of the primary node. if
the heart beet stops it assumes that the primary server is
down andd this passive node immediately comes online and
accepts the user connections which in turn is a high
availability solution.

By using the cluster in the organization the database might
be online in most of the cases except that the nas or both
the servers are down.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is an execution plan? When would you use it?

0 Answers  


What is Primary key and foreign key? Give an example

4 Answers   TCS,


Explain aggregate functions?

0 Answers  


how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


What is indexed view?

0 Answers  


What is the difference between join and inner join?

0 Answers  


How to maintain a fill factor in existing indexes?

0 Answers  


Explain how to maintain a fill factor in existing indexes?

0 Answers  


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  


What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  


How to concatenate two binary strings together?

0 Answers  


Categories