What are the different types of replication? How are they used?
- 3 Answers
- 12310 Views
- I also Faced
- E-Mail Answers
Answer Posted / suguk
The are three types Replication are
*Unidirectional*Bidirectional*Peer-Peer
*unidirectionalReplication
Transactions that occur at a source table are replicated
over WebSphere® MQ queues to a target table or are passed
as input parameters to a stored procedure to manipulate the
data.
Transactions that occur at the target table are not
replicated back to the source table.
The target table typically is read only or is not updated
by applications other than the Q Apply program.
*Bidirectional
Number of replication queue maps
Between each pair of servers that participate in
bidirectional replication, you need two replication queue
maps. For example, if you have two servers named SERVER_RED
and SERVER_GREEN, you need two replication queue maps:
One to identify the WebSphere® MQ queues that transport
data from SERVER_RED to SERVER_GREEN
One to identify the WebSphere MQ queues that transport data
from SERVER_GREEN to SERVER_RED
Number of Q subscriptions
For every logical table that is replicated in bidirectional
replication, you need a pair of Q subscriptions between the
two servers. For example, if you have two servers named
SERVER_RED and SERVER_GREEN, then two Q subscriptions are
built for you:
One from the source table on SERVER_RED to the target table
on SERVER_GREEN
One from the source table on SERVER_GREEN to the target
table SERVER_RED.
*Peer-peer
Peer-to-Peer applications are defined as programs which
allow computers to share data in the form of music, movies,
games or any computer file or software over a local network
and the Internet. Fordham University does not, at this
time, prohibit and does not block the use of peer-to-peer
applications on any part of its network. The University
understands that there are legitimate academic uses for
such applications. However, use of these applications has
been known to cause problems, which can affect the entire
University community.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What does asynchronous call backs means?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How do users use Report Builder with SQL Server data sources?
Which are ddl commands?
What is attribute? : sql server analysis services, ssas
last function used in MS Access to convert sql what function will use in sql
List some major differences between triggers and stored procedures?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How secure is sql server database?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to select all columns of all rows from a table with a select statement in ms sql server?
Are all views updatable ?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What does null mean?
