I'm running postgresql on a two machine
intermezzo cluster (www.inter-mezzo.org).
I haven't tested it with a heavy load yet -
maybe today, but it works under a light load, with
bidirectional replication of the file system containing
the database (/var/lib/pgsql). The goal
of course is to incorporate these real servers
into a scalable load balancing high availability
distributed cluster.
Each machine is running postmaster, a
seeming violation of the man page prohibition
against running more than one postmaster on
a postgres database. This is necessary,
because the system must be fully functional even
when one machine is taken off line.
I don't thing this should be a problem,
since as I understand it, table and row
locking occurs at the postgres backend level
and lock files are kept in a database table,
itself replicated across the intermezzo file system.
Can anyone think of any reason why this might
not work under a heavy load? My load test
later today or tomorrow on my two node cluster
will only partly answer this question.
I'm using the latest CVS version with kernel 2.4.18.
Robert Williams