Enabling/Disabling Table Filters on a Primary node v6.2

Table filters must first be defined in a set of available table filters in the publication before they can be enabled on a primary node. See Section Adding a Publication for information on defining table filters in a multi-master replication system.

The following are the steps for enabling or disabling table filters on an existing primary node.

Step 1: Make sure the publication server whose node is the parent of the primary nodes of the replication system is running and has been registered in the xDB Replication Console you are using. See Section Registering a Publication Server for directions on starting and registering a publication server.

Step 2: Select the Publication Database node corresponding to the primary node on which you wish to enable or disable individual filter rules.

Figure 6-64: Selecting a primary node on which to enable or disable filter rules

Step 3: Click the secondary mouse button on the Publication Database node and choose Update Filter Rule.

Figure 6-65: Opening the Filter Rules tab on a primary node

The primary node you choose as the new primary definition node should contain a superset of, or at least an equivalent set of data as the current primary definition node. The reason for this is to ensure that the former primary definition node contains the complete set of data satisfying the filtering criteria after you take a snapshot from the new primary definition node to the former primary definition node on which you just enabled the table filters.

Step 4: In the Filter Rules tab check or uncheck the boxes to specify the filter rules to enable or disable on the primary node. At most one filter rule may be enabled on any given table. Click the Save button.

Figure 6-66: Filter Rules tab

Step 5: A confirmation box appears presenting a warning message and a recommendation to perform a snapshot replication to any primary node on which you changed the filtering criteria.

Click the Ok button in the confirmation box to proceed with the update to the filter rule selections. Click the Cancel button to return to the Filter Rules tab if you wish to modify your filter rule selections.

Figure 6-67: Change filter rule confirmation

Step 6: If you clicked the Ok button in the preceding step, the Filter Rules updated successfully confirmation message appears if the update was successful.

Figure 6-68: Successful update of filter rules

If you clicked the Cancel button in the preceding step, the Filter Rules tab reopens. You can modify your filter rule selections by repeating Step 4, or you can click the Cancel button in the Filter Rules tab to abort the filter rule updates on the primary node.

Step 7: It is strongly recommended that a snapshot replication be performed to the primary node that contains tables on which the filtering criteria has changed.

A snapshot ensures that the content of the primary node tables is consistent with the updated filtering criteria. See Section Performing Snapshot Replication for information on performing a snapshot replication.

On the contrary, if the primary definition node contains only a subset of all the data contained in the other primary nodes, then a snapshot to another primary node may not result in the complete set of data that is required for that target primary node.