Hello! Currently I had to disable pgpool, because of the following problems:
- no real logging support - too often disconnects: 2008-05-30 09:45:19 LOG: pid 15208: statement: begin; select data from php_sessions where session_id = 'cd4752abe 216370eeec09e8dde9354f7' for update; 2008-05-30 09:45:19 LOG: pid 15252: statement: begin; select data from php_sessions where session_id = '87df8fc96 924eba9999f2aceb3dfbd5b' for update; 2008-05-30 09:45:19 LOG: pid 14567: statement: RESET ALL 2008-05-30 09:45:19 LOG: pid 14567: statement: SET SESSION AUTHORIZATION DEFAULT 2008-05-30 09:45:19 ERROR: pid 15252: pool_process_query: 1 th kind C does not match with master connection kind D 2008-05-30 09:45:19 LOG: pid 15252: notice_backend_error: 1 fail over request from pid 15252 2008-05-30 09:45:19 LOG: pid 5045: starting degeneration. shutdown host 62.65.130.180(6543) There are just too many situations, when a node is disconnected - problems on syncing, even with PITR: As the applications do not release the connection from pgpool, the pgp_recovery_node only works if I restart pgpool and insert an iptables -j REJECT to the right port before the whole sync -> more downtime than just for PITR - connection problems when one backend is down / the available connections at the backends are full: no answer from pgpool - no / wrong reuse of existing connections: pgpool opens up to the maximum number of connections persistent to the backends, but does NOT reuse them until all are opened (afaics) -> leads to strange behaviour if the last made connections (see above) Currently I just setup a BIG server instead of a cluster with a cold-standby node. If I see imrovements in pgpool I'll give it a try again, but the pgpool-II 2.1b2 version is not usable yet. Sincerly Nico -- Think about Free and Open Source Software (FOSS). http://nico.schottelius.org/documentations/foss/the-term-foss/ PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C
signature.asc
Description: Digital signature
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
