From moch_isnaini@yahoo.com Tue Apr 24 07:35:45 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 204699FB8AA for ; Tue, 24 Apr 2007 04:35:45 -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 49338-01 for ; Tue, 24 Apr 2007 04:35:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web30809.mail.mud.yahoo.com (web30809.mail.mud.yahoo.com [68.142.200.152]) by postgresql.org (Postfix) with SMTP id 575099FB8A9 for ; Tue, 24 Apr 2007 04:35:39 -0300 (ADT) Received: (qmail 58370 invoked by uid 60001); 24 Apr 2007 07:35:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=LP76ptIu3K+GDYrwfqldmpAUpXBbshlPZY08amdfBMhccDVMScLqviN20QVLZ7qOUPXAHayy58/JJk9H10ueSn40USuZ4Azx27lg5qLmIcyyCs1Yp/BYW4+IaMeY/wVEokAHmeAQ8JWVB2WXbkbT6HhPXwcv8ad9ucOnLoUO7vw=; X-YMail-OSG: YBKvC_AVM1kIok2rzBQo23mRR.Lp1dvFcUR_0wHD53GNBVA6CjqkAQnKInANaZi7wA-- Received: from [202.154.62.68] by web30809.mail.mud.yahoo.com via HTTP; Tue, 24 Apr 2007 00:35:37 PDT Date: Tue, 24 Apr 2007 00:35:37 -0700 (PDT) From: Muhammad Isnaini Subject: Replication Multi Master Asyncronous To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-212077688-1177400137=:57691" Content-Transfer-Encoding: 8bit Message-ID: <104236.57691.qm@web30809.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.718 tagged_above=0 required=5 tests=BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_IMAGE_ONLY_12=1.867, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: *** X-Archive-Number: 200704/214 X-Sequence-Number: 25278 --0-212077688-1177400137=:57691 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 . thanks for advice. --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. --0-212077688-1177400137=:57691 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 .

thanks for advice.


Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos. --0-212077688-1177400137=:57691-- From bnichols@ca.afilias.info Tue Apr 24 18:17:23 2007 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.