On Wed, April 23, 2008 4:06 pm, Tatsuo Ishii wrote: > Thanks for the report. If you try to use pgpool-II with replication > mode, I could help you as far as I can. I hope your project going > well.
Hi there Tatsuo Ishii, As promised, here's the feedback (albeit belatedly). Following on with regards the issue with PgPool 1 sometimes sending SELECTs to the master when it's not supposed to, it looks like PgPool 2 is doing the same (ie, with backend_weight0 = 0). I'm still seeing the occasional SELECT from the slaves being executed on the master. The patch you provided was for PgPool 1, any idea on what changes would be required for PgPool 2? ie, if backend_weightN = 0, then do *not* load balance SELECTs to node N. I had a look at the code and noticed that the logic has changed a bit, but I'm not sure what to tweak to test (sadly, I don't have the time to really study the code). Regards Henry _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
