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 |
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
What is the difference between the 2 operating modes of database mirroring?
Why do you want to join software field as you have done your BE in Electronics?
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
What is usually the first word in a sql query?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
What is self join in sql server joins?
What is inner join? Explain with an example?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are different types of collation sensitivity?
How to create a dml trigger using create trigger statements?
Can you explain what are commit and rollback in sql?
Oracle (3259)
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)