From: | "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com> |
---|---|
To: | <jim(at)spectrumtelecorp(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: clustering and/or failover? |
Date: | 2001-08-21 13:41:15 |
Message-ID: | HOEFIONAHHKFEFENBMNOCEDGCBAA.rsanford@nolimitsystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
what software are you running for this? where can i find it?
thanks!
rjsjr
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Jim
> Buttafuoco
> Sent: Tuesday, August 21, 2001 6:53 AM
> To: Robert J. Sanford, Jr.; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] clustering and/or failover?
>
>
> Robert,
>
> I have been running a "heartbeat" PG database cluster for
> a year now using a shared SCSI bus. Yes the heartbeat
> software has to be careful about when to mount the disk
> and on what system. But this seems to work well (I did
> a lot of testing before putting into production.) This
> is a pure master/standby cluster config.
>
> Jim
>
>
> > thinking in the long-term for my project...
> >
> > i'm looking at trying to set up two database servers with
> > some sort of clustering and/or failover that are talking
> > to a SAN. is this even feasible using postgres?
> >
> > using ms sql server as an example (because that is what
> > my office is currently using) you can set up two database
> > servers that will check each other's heartbeat to see if
> > they are both up. if one goes down then the other takes
> > over responding to requests. you can also set up a
> > cluster that will have both machines responding to
> > requests concurrently.
> >
> > with the data set up on a fibre channel raid box you
> > don't have to worry about replication, you just have to
> > make sure that the data is properly locked by each of
> > the servers (in the clustering example) so that no two
> > machines are updating the same data at the same time.
> >
> > i am fairly certain that postgres cannot handle the
> > first example (heartbeats) but am wondering if it can
> > handle the second example where two instances are
> > hitting the same physical data store.
> >
> > many thanks!
> >
> > rjsjr
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> > (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
> >
> >
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Buttafuoco | 2001-08-21 14:01:48 | RE: clustering and/or failover? |
Previous Message | Stephan Szabo | 2001-08-21 12:54:27 | Re: Sort by foreign date column |