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 |
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What command must you use to include the not null constraint after a table has already been created?
What is the difference between push and pull subscription? : sql server replication
Can group functions be mixed with non-group selection fields in ms sql server?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How do you rename a table in sql server?
How can I get data from a database on another server?
Difeerence between ssis 2005 and ssis2008?
What are entities and relationships?
Explain database normalization?
IN Vs OR operator which is best to use sql server.
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
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)