> > > 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?
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
