David Parker dparker
Tue Sep 28 15:46:41 PDT 2004
I'm working on a Java API for the slony management stored procedures,
using slonik.c as my guide. Our application consists of many servers
clustered in pairs for redundancy, and we need a management facility
that can handle dynamically adding a machine to a cluster, including
configuring the database schema and replication.

If I want to provide a method that adds a table to a set regardless of
whether that set is subscribed or not, it looks like the steps would be:

1) create a temporary set and add my desired table
2) create subscriptions to that set for every subscriber to my target
set
3) call mergeset procedure

The management functionality I'm building will be responsible for
knowing that the added table exists on all nodes.

Do these steps make sense? I'm curious about timing issues - do I need
to make sure that the subscriber nodes have processed the temporary set
creation before I do the mergeset?

Thanks in advance for any feedback.

-  DAP
====================================================== 
David Parker    Tazz Networks    (401) 709-5130
 


More information about the Slony1-general mailing list