What is Peer to peer Replication?

Answer Posted / aruna gopalakrishnan

Peer-to-peer replication (also known as multimaster
replication) is a configuration that has the following
characteristics:

Replication occurs between tables on two or more servers.
Updates on any one server are replicated to all other
associated servers.
Applications on any of the servers can update the same rows
and columns in those tables at the same time.
All servers are equal peers with equal ownership of the
data; no server is the "master" or source owner of the
data.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are sparse columns?

742


What are approximate numeric data types in ms sql server?

749


Explain what are the basic functions for master, msdb, model, tempdb databases?

701


What is lookup override?

763


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

748






What are different types of views?

696


What do you understand by replication in sql server? Mention the different types of replication in sql server.

691


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

643


What is a database table?

692


What is filestream?

736


What are the different kinds of ssrs reports?

190


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1710


What is the Difference Between Primary and Foreign Key?

745


Does an index slow down updates on indexed columns?

715


What are locks in sql?

701