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:

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.