[Linux-cluster] Advice on setting up Resources for Postgres

[Jeff Stoner]

> -----Original Message-----
> I'd use GFS to make sure that data is not corrupted. You can 
> "live" with
> ext3 -- but in case of a problem, if two postmaster directly 
> accesses the same node, data problem may occur.

It's not just "if 2 systems access it at the same time" - the filesystem
itself my get corrupted (yes, I've seen journaled filesystems get
corrupted.)  Which means the filesystem on a SAN becomes a single point
of failure. For this reason, I have a 3rd MySQL server set up as a slave
replication server to my clustered MySQL database. It provides that
extra layer of protection against this SPoF.

Food for thought.

--Jeff
SME - UNIX
OpSource Inc.

PGP Key ID 0x6CB364CA