SEO

#1 (**permalink**) 04-10-2008, 07:27 AM

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.

#2 (**permalink**) 04-10-2008, 07:27 AM

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.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Replication Multi Master Asyncronous