Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7E27D9FB9AE for ; Tue, 24 Apr 2007 15:17:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 64645-06 for ; Tue, 24 Apr 2007 15:17:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id B519B9FB803 for ; Tue, 24 Apr 2007 15:17:19 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1HgPZl-0003Mu-Vk; Tue, 24 Apr 2007 14:17:18 -0400 Subject: Re: Replication Multi Master Asyncronous From: Brad Nicholson To: Muhammad Isnaini Cc: pgsql-admin@postgresql.org In-Reply-To: <104236.57691.qm@web30809.mail.mud.yahoo.com> References: <104236.57691.qm@web30809.mail.mud.yahoo.com> Content-Type: text/plain Date: Tue, 24 Apr 2007 14:17:17 -0400 Message-Id: <1177438637.6120.19.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/219 X-Sequence-Number: 25283 On Tue, 2007-04-24 at 00:35 -0700, Muhammad Isnaini wrote: > Hi.. > I success develop a Replication Multi Master Async through PHP. > Just few step to make replication with php, but I want to make this > replication can embedded into PostgreSQL. > > This step by step . > Make every record unique in every > Every table that create must added by 1 Field ( ex : clusterid ). > Every primary key must changed to add clusterid. > Every update ( insert and update ) must corelation with clusterid. > Make Update / Insert to Log > Send Log to another member cluster. > Every member cluster Execute Log that receive. > Send message that to Sender. > Delete log. > > That's model that I want to make code . How are you planning on handling collision detection and resolution? -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.