How You Implement Horizontal Partitioning Using Replicator Manager

8. Using Advanced Features : Lookup Tables : How You Set Up Horizontal Partitioning : How You Implement Horizontal Partitioning Using Replicator Manager

Share this page

After you create and populate the lookup table in every participating database, you must implement horizontal partitioning using one of the appropriate Ingres tools.

To implement horizontal partitioning using Replicator Manager, follow these steps:

1. Define all the databases that participate in the partitioning in the Database Summary window.

For more information, see Add a Database to the Database Summary List.

2. Add new CDDSs for horizontal partitioning in the CDDS Summary window, with a different CDDS for every partition.

For more information, see Add a CDDS.

3. Add database and Replicator server information for each new CDDS in the CDDS Databases and Servers window.

For more information, see Add Database and Server Information.

4. Add propagation paths for each new CDDS in the Propagation Path Definition window. If the base CDDS is present in only a single database, it does not need any propagation paths.

For more information, see Add Propagation Paths.

5. Register the base table to be partitioned from the Table Registration Summary window.

For more information, see Register Tables.

The lookup table also appears in the Table Registration Summary window because it is a table in the database. However, it need not be registered for replication.

Note: The lookup tables are expected to be static; ordinarily they are not replicated. If desired, they can be registered. However, keep in mind that changes to the lookup table must be propagated ahead of rows in the base table or the partitioning scheme breaks down.

6. Choose Edit from the Table Registration Summary window, and enter the new CDDS number for the base table in the Table Registration Details window.

For instructions, see Assign a Table to a Different CDDS.

7. Specify the horizontal partitioning lookup table to the base table in the Table Registration Details window.

For more information, see Assign Lookup Tables.

8. Continue with configuration procedures as explained in the chapter “Configuring Replication Using Replicator Manager.”