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
What is the stuff?
explain different types of cursors? : Sql server database administration
What is difference between joins and subqueries?
What is sql injection and why is it a problem? : sql server security
Can binary strings be used in arithmetical operations?
What are the encryption mechanisms in sql server?
How to create a large table with random data for index testing in ms sql server?
Can we delete data from a view?
What is the use of keyword with encryption.
Mention the different types of replication in sql server.
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What the different types of Replication and why are they used?
what are the Prerequisites for Replication?
What command would you use to add a column to a table in sql server?
What is right outer join in sql server joins?