On Fri, May 19, 2006 at 06:10:49PM -0400, Andrew Sullivan wrote:
> 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 *.

Maybe I missed something, but wasn't the OP trying to replicate data
from slaves back up to the master?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461