[Pgcluster-general] async replication

[Atsushi Mitani]

Hi Kevin,

> I got PGCluster (on 8.2.3) working in my environment.
> A simple (but very busy - 8000 requests/sec) setup:
Oh, Greate!
It's my surprise.

> My question is this: would it be feasible to add a asynchronous mode to
> PGCluster?

First of all, I'm afraid that PGCluster doesn't have asynchronous mode.

BTW, I'm a bit confusing, since PGCluster doesn't replicate the "data reading query (i.e SELECT)", 

If there is no "data writing query(i.e. UPDATE/INSERT/DELETE)" in the developer's query,
I recommend set 'true' to 'not_replicate_prepared_select' in the postgresql.conf.

If you just need the shapshot DB for development purpose,
you can create it with 'pg_dumpall' & 'pgrestore'.

Would you explain more detail about contents of each queries. 

Regards,

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

 
---------------------------------
Easy + Joy + Powerful = Yahoo! Bookmarks x Toolbar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080229/7adf9b52/attachment.html