[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