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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / vamsimadineni


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

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

Can we install sql server 2016 on windows 7?

0 Answers  

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

What is a schema in ms sql server 2005?

0 Answers  

Which are the new data types introduced in sql server 2008?

0 Answers  

Why we need sql server?

0 Answers  

What is database dimension? : sql server analysis services, ssas

0 Answers  

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

What is the difference between a stored procedure and a user defined function?

0 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories