Christopher Browne cbbrowne
Fri Feb 25 23:02:01 PST 2005
Moving a step closer to readiness for releasing a version 1.1, the
"CVS HEAD" version of Slony-I supports log shipping for the SYNC event
(implemented by Jan Wieck), and for DDL_SCRIPT (implemented by
myself).

The events that exist may be partitioned into the following sets:

1.  Events that log shipping presently supports

SYNC
DDL_SCRIPT

2.  Events that log shipping needs to support

SUBSCRIBE_SET

 - This will require generating a COPY statement for each table in the
   set; changes copy_set() in remoteworker.c

MOVE_SET
MERGE_SET
UNSUBSCRIBE_SET

 - These are fairly simple; they just involve modifying the contents
   of the log shipper table "sl_setsync_offline" to indicate the
   change/removal of data sources...

I'll hopefully be looking at these early next week.

3.  Events that log shipping does not need to support _AT ALL_ due to
"contextual irrelevance."

Since log shipping doesn't require communication with other nodes
(it's a 1-way receiver of data), it does not need to be aware of other
nodes, paths, listens, or sets (per se...)

STORE_NODE
ENABLE_NODE
DROP_NODE
STORE_PATH
DROP_PATH
STORE_LISTEN
DROP_LISTEN
FAILOVER_SET
RESET_CONFIG

4.  Events that log shipping doesn't need to support because the
effects are implicit on the node that is collecting logs.

STORE_SET
DROP_SET
SET_ADD_TABLE
SET_ADD_SEQUENCE
SET_DROP_TABLE
SET_DROP_SEQUENCE
SET_MOVE_TABLE
SET_MOVE_SEQUENCE
STORE_TRIGGER
DROP_TRIGGER
ENABLE_SUBSCRIPTION
-- 
"cbbrowne","@","ca.afilias.info"
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


More information about the Slony1-general mailing list