[Pgpool-general] pgpool-II documentation

[Tim Uckun]

>
>
> There are simple rules:
>
> 1) Always send queries to all the nodes if it's a write query
>

I presume this can lead to inconsistencies in data if your queries use non
deterministic functions like "now" or if your tables have serial data types
for IDs.


>
> 2) Detach a node if it fails.
>
> 3) Always execute queries in a transaction. If a node fails, the
>   transaction aborts to rollback to previous data.



Does it fail the entire update? In other words does  the record commit on
some servers and not others?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090409/6987e55a/attachment.html