Hello, the pgfoundry project seems to be the initial start of cybercluster offered by CyberTec from Austria (German page: http://www.postgresql-support.de/pr_cybercluster.html). As far as I know this is a modified/adapted pgcluster solution. We're very happy with pgpool-II for load-balancing and multi-master usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to avoid a SPOF, e.g. with heartbeat). regards...GERD... Tim Uckun schrieb: > > > On Wed, Feb 11, 2009 at 11:24 PM, Serge Fonville > <serge.fonville@xxxxxxxxx <mailto:serge.fonville@xxxxxxxxx>> wrote: > > Hi, > > I am in the process of setting up a two node cluster. > Can PostgreSQL use DRBD as its storage? > Since the in-memory database would be synchronized with the on-disk > database. > If this would be done with every query, this would greatly impact > performance. > Since the cluster will be multi-master/dual-primary, do I need to > have a separate block device for each PostgreSQL instance or can it > use the DRBD device? > I read mostly about MySQL clustering with DRBD and there the query > cache should be disabled to make sure data is in-sync. > To me it seems something similar would apply to PostgreSQL. > I believe cybercluster is the most active and complete PostgreSQL > clustering solution. > My endgoal is a two node cluster with load sharing and fail over > where both nodes can perform reads and writes. > > > > After reading your post I decided to check out cybercluster. In > PgFoundry there is a cybercluster project > http://pgfoundry.org/projects/cybercluster/ but it hasn't been updated > since 2007. > > Is that the one you are talking about or is there another cybercluster I > should be looking at. > > Also.... > > > Is there an article or something that compares the different HA > solutions for postgres? What are the differences between pgpool, > pgcluster, cybercluster etc? > > > Any HOWTOs anywhere? > > Thanks. > > -- /===============================\ | Gerd König | - Infrastruktur - | | TRANSPOREON GmbH | Pfarrer-Weiss-Weg 12 | DE - 89077 Ulm | | | Tel: +49 [0]731 16906 16 | Fax: +49 [0]731 16906 99 | Web: www.transporeon.com | \===============================/ Bleiben Sie auf dem Laufenden. Jetzt den Transporeon Newsletter abonnieren! http://www.transporeon.com/unternehmen_newsletter.shtml TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056 Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
