What is Peer to peer Replication?
Answer / 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 |
What are the types of indexes?
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
Why use cursor in sql server?
Write a SQL command to insert and update only a particular field?
How to drop an existing user defined function in ms sql server?
How to get the query of a table in sql server?
How to provide default values to function parameters?
How to create nested stored procedure?
What is the correct order of the logical query processing phases?
what is difference between view and Dip.
What are secondary xml indexes?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)