Data
Replication
MultiValue Data Replication
MultiValue data replication allows database administrators to distribute data across multiple servers throughout an organization. You may wish to implement replication in your organization for a number of reasons, such as:
Load balancing
Replication allows you to disseminate your data to a number of servers and then distribute the query load among those servers.
Offline processing
Replication supports manipulating data from your database on a machine that is not always connected to the network.
Redundancy
Replication allows you to build a fail-over database server that’s ready to pick up the processing load at a moment’s notice. Any replication scenario has two main components:
● High Availability
● Disaster Recovery
Publishers
have data to offer to other servers. A given replication scheme may have one or more publishers.
Subscribers
are database servers that wish to receive updates from the Publisher when data is modified.