[Pgcluster-general] Last chance to get everything working

[Christian Dannemann]

Hi John,

we had pgcluster running in production for about 3 weeks and then 
stopped as we had huge problems with the cluster just hanging without 
any reason - as this was driving a web site with a huge turnover, we 
found the performance to be unacceptable and are now back to using 
postgresql without replication.

Regards,

Christian


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
>