Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Planning and designing for Enterprise ReplicationBefore you set up your replication system, plan how to include Enterprise Replication into your database server environment, design your database schema by following Enterprise Replication requirements, and then design your replication system between database servers.
Replication system designWhen you design a replication system, you make three main decisions: how the information flows between servers, how to resolve conflicts between replicated data, and the topology of the network of servers.
Primary-Target Replication System
Workload PartitioningWorkload partitioning gives businesses the flexibility of assigning data ownership at the table-partition level, rather than within an application.

Workload Partitioning

Workload partitioning gives businesses the flexibility of assigning data ownership at the table-partition level, rather than within an application.

The following figure illustrates workload partitioning.

begin figure description - This figure is described in the surrounding text - end figure description — Figure 1: Workload Partitioning in a Primary-Target Replication System

The replication model matches the partition model for the employee tables. The Asia-Pacific database server owns the partition and can therefore update, insert, and delete employee records for personnel in its region. The changes are then propagated to the US and European regions. The Asia-Pacific database server can query or read the other partitions locally, but cannot update those partitions locally. This strategy applies to other regions as well.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.