On Fri, May 19, 2006 at 04:24:23PM -0500, Jim C. Nasby wrote:
> On Thu, May 18, 2006 at 10:41:37AM -0400, Andrew Sullivan wrote:

> > No.  But you could alter your source tables to have a source_machine
> > column.
> 
> How would that allow for replicating from many into one?

You need to alter your indexes too.  So instead of a unique index on
(say) id, you put it on (id, hostid).  Then you can have colliding
ids, but it doesn't matter, because the real key is (id,hostid).

It's tricky, but you can often do it without application changes, as
long as you never do something dumb like SELECT *.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
		--Philip Greenspun