Advantages of Replicating Local Data

Replicating tables on local data servers provides clients with local access to enterprise data, which results in improved performance and greater data availability.

Improved Performance

In a typical Replication Server system, data requests are completed on the local data server without accessing the WAN. Local clients gain improved performance because:

Data transfer rates are faster on a LAN than they are on a WAN.
Local access remains unaffected by network traffic over the WAN. Local clients that share local data server resources do not compete with the enterprise-wide user community for central resources.

Greater Data Availability

Because data is replicated at local and remote databases in a Replication Server system, clients can operate in a fault-tolerant environment so that:

When a failure occurs at a remote database, clients can use local copies of replicated data.
When a WAN failure occurs, clients can use local copies of replicated data.
When the local data server fails, clients can use replicated data at another site.

Network failure or database failure at other locations do not halt work at the local database. When WAN communications fail, Replication Server stores operations on replicated tables in stable queues (disk storage). The replicated tables at the unavailable databases are updated when communications resume. If a local data server fails, clients can continue working by temporarily accessing a replicate copy of the data.