Interested to Buy Any Domain ? << Click Here >> for more details...
Please tell me some knowledge about Clustering and how to
add clustering?
- 1 Answers
- 3802 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
explain different levels of normalization? : Sql server database administration
whats the maximum size of view state??
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What are the properties and different types of sub-queries?
List out some of the requirements to set up a sql server failover cluster?
How to create sub reports?
What functions can a view be used to performed?
Determine when an index is appropriate?
What is an identity column in insert statements?
What is the stored procedure?
how can a database be repaired? : Sql server administration
What are the built in functions in sql server?
What is normalization? Explain its different types?
What are the various editions of sql server 2017 that are available in the market?
How can you ensure that the database and sql server based application perform well?
