From: Scott Marlowe <scott.marlowe@gmail.com>
To: Andreas Philipp <andreas.philipp@clinicauniversitariateleton.edu.co>
Cc: pgsql-admin@postgresql.org
Subject: Re: Advice on running two database clusters on one server machine
Date: Mon, 16 Jun 2008 20:43:30 -0600
Message-ID: <dcc563d10806161943g39a65285q5cd9b8ba5d4a04ce@mail.gmail.com> (raw)
In-Reply-To: <72fa1b080806151011h357edc5bm92af30e08aeefd61@mail.gmail.com>
References: <72fa1b080806151011h357edc5bm92af30e08aeefd61@mail.gmail.com>
On Sun, Jun 15, 2008 at 11:11 AM, Andreas Philipp
<andreas.philipp@clinicauniversitariateleton.edu.co> wrote:
> Hi all,
>
> We are implementing a hospital information system and a human
> resources/payroll processing system on two identical dedicated servers with
> two Xeon Quad Core processors and 32 GB RAM each, both servers being attached
> via FC to a SAN, and both applications running on PostgreSQL 8.3 / CentOS 51.
>
> We are wondering about the advisability to distribute the databases between
> the two server machines, both machines acting as active production systems
> for one application each, and as warm standby servers for the other, using
> WAL shipping to a second database cluster running on another port on each of
> the two server machines.
>
> What would be the performance cost of doing so, rather than running all
> databases on one database cluster on one machine, and using the second
> machine as a warm standby server for all databases of the two applications?
Well, when both machines are working, your performance would be better
on two machines than on one. But after a failover, the warm standby
will be running two instances of postgresql, and that's sub-optimal.
> What other considerations should we take into account? We have no prior
> experience with PostgeSQL administration, having run our previous systems on
> Windows Servers and MS SQL Server.
Also, worry about the possibility of switching the wrong databases
when things are going wrong, etc with this type of setup.
However, the biggest concern is your FC-SAN setup. Some are very
fast. Some are quite pokey, and once you buy them, the manufacturer
will just laugh and point their fingers at linux, postgresql, or the
phase of the moon as the cause of your performance problem and do
nothing more.
If you haven't tested your FC-SAN setup with both servers running
comlex benchmarks (multiple bonnie++ instances, lots of dds, etc...)
and proven that it's fast, don't expect it to be.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, andreas.philipp@clinicauniversitariateleton.edu.co
Subject: Re: Advice on running two database clusters on one server machine
In-Reply-To: <dcc563d10806161943g39a65285q5cd9b8ba5d4a04ce@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox