Interested to Buy Any Domain ? << Click Here >> for more details...
Please tell me some knowledge about Clustering and how to
add clustering?
- 1 Answers
- 3862 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
Why do we need different type of parameter?
How to use subqueries with the exists operators in ms sql server?
How to delete duplicate rows from table except one?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What can be used instead of trigger?
What are locks in sql?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to invoke a trigger on demand?
How to create a Master database in SQL server ?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to concatenate two binary strings together?
What is the difference between varchar and nvarchar datatypes?
What's the information that can be stored inside a bit column?
What is “asynchronous” communication in sql server service broker?
What are the purposes and advantages stored procedure?
