[Pgpool-general] Questions regarding replication mode

[Anthony MacKinnon]

Hi,

 

We are trying to get pgpool working in replication mode with load balancing.
There are a few questions we're trying to find answers to:

-          Does pgpool detect data mismatches by executing the queries on
all backends and comparing the results? If so, how does this work with query
load balancing turned on (i.e. queries are only sent to one backend)?

-          In PostgreSQL, INSERT statements increment sequence numbers
(using serial primary keys) even if they fail. In such cases, would the
failed statement get executed on all backends? If not, how does pgpool
prevent a data mismatch on the sequence?

 

Any help would be appreciated.

 

Regards,

Anthony

 

_________________________________

Anthony MacKinnon

Software Architect

Waypoint Information Technology Inc.

Office: 613.224.9376 ext.17

Mobile: 613.867.5344

 

www.waypointinfo.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080103/64182f00/attachment.html