[Pgcluster-general] Last chance to get everything working

[Rick Vernam]

Is there a trend here that jdbc->pgcluster does not work well?

On Wednesday 23 May 2007 03:46:17 am John Gardner wrote:
> I've been working with pgCluster for the last four months now, I'm at
> the stage where we need to install it in a production environment, but I
> must say that I'm still apprehensive about a few things, some things
> certainly don't work in my environment.  I have chatted with Rick Vernam
> about a few of these problems, and although we seem to have the same
> configuration, his works and mine doesn't.
>
> My configuration is this:
>
>     DB 1               DB 2                                DB 3
> +--------------+   +--------------+                  +--------------+
>
> |   cluster_1  |   |   cluster_2  |       VPN        |   cluster_3  |
> |   rep_1      |---|   rep_2      |------------------|   rep_3      |
> |   lb_1       |   |   lb_2       |                  |              |
>
> +--------------+   +--------------+                  +--------------+
>
>
> +--------------+   +--------------+
>
> |   Apache     |   |   Apache     |
> |   mod_jk     |   |   mod_jk     |
> |   Tomcat     |---|   Tomcat     |
>
> +--------------+   +--------------+
>      APP 1		APP 2
>
> My problems are:
>
> - Replication works between all of the nodes under normal circumstances.
> - Multiple replicator failover doesn't work.
> - Occasionally when bringing a DB Cluster node back up in recovery mode,
> access to the remaining DB clusters locks and I can't access anything
> either via the load balancer or directly.
> - Does <Response_Mode> have any use at all? One of the reasons for going
> down the pgCluster route was the 'normal' operation, but I've just read
> a post on the mailing list from Atsushi saying that normal operation
> doesn't work and should be removed.
> - What is the difference of setting <Use_Replication_Log> to yes or no?
>
> We really, have to make a decision this week, whether we stick with
> pgCluster or go via another route.  I've stuck with pgCluster for this
> long because I was convinced that the reason it was not performing as I
> had expected was due to configuration errors, but now I'm not so sure...
> If anyone can give me any help I would be extremely grateful!
>
> Thanks in advance
>
> John
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general