[Pgpool-general] Data not same on both nodes, streaming replication & load balancing

Armin Nesiren armin.nesiren at intera.si
Tue Sep 20 10:03:58 UTC 2011


Hi everyone,

I have configuration pgpool streaming replication & load balancing
configuration with two nodes.
pgpool version is 3.1.0-alpha2 (hatsuiboshi), postgres on both nodes is
9.0.4

Reason why I have use this version is that latest stable version (at that
time) 3.0.1 was everything
but not stable.

Anyway.. I have situation now.. that my slave node is containing different
data from master node.
I select something from master and get one result, and same query from slave
and I get different result.

How to prevent this happening, and how it is possible that this happened.
How to know data my other data is health?

Thanks.

-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110920/1460389b/attachment.html>


More information about the Pgpool-general mailing list