[Pgcluster-general] technical question

[a.mitani at sra-europe.com]

Hi,

PGCluster is using a "query based relication".
And all data writing query is set queue in replication server.
Each replicated query execute from this queue one by one.

Transaction isolation is controled in each Cluster DB it self.
It's a simple, isn't it :)

------------------------------
At.Mitani

> As pgcluster uses statement replications, I've wondered how it deals
> with the usual problems of MVCC-based systems in relation to statement
> replication?
>
> E.g. How does it deal with multiple READ-COMMITED transaction? These
> are strictly timing sensitive?
>
> INSERT INTO history (_time, id, value) VALUES (now(), 10, (SELECT
> somevalue
> FROM table WHERE id=10));
>
> Andreas
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>