Modifying Replicates

You can modify replicates in two ways:

• Adding or Deleting Participants
• Changing Replicate Attributes

Adding or Deleting Participants

To be useful, a replicate must include at least two participants. You can define a replicate that has fewer than two participants, but before you can use that replicate, you must add more participants.

To add a participant to an existing replicate, use the cdr change replicate --add command. For example, to add two participants to the sales_data replicate, enter:

cdr change replicate --add sales_data \
   "db1@hawaii:jane.table1" "select * from table1" \
   "db2@maui:john.table2" "select * from table2"

To delete a participant from the replicate, use the cdr change replicate --delete command.

For example, to delete these two participants from the replicate, enter:

cdr change replicate --delete sales_data \
   "db1@hawaii:jane.table1" "db2@maui:john.table2"

For more information, see cdr change replicate.

Changing Replicate Attributes

You can change the following attributes of a replicate using the cdr modify replicate command:

• Conflict-resolution rules and scope
• Replication frequency
• Error logging
• Replicate full rows or only changed columns
• Database triggers
• Participant type

You cannot change the conflict resolution from ignore to a non-ignore option (time stamp, SPL routine, or time stamp and SPL routine). You cannot change a non-ignore conflict resolution option to ignore.

For information on each of these attributes, see Defining Replicates.

For example, to change the replication frequency for the sales_data replicate to every Sunday at noon, enter:

cdr modify replicate sales_data Sunday.12:00

For more information, see cdr modify replicate.