From: Christian Fowler <spider@viovio.com>
To: Kent Anderson <kenta@ezyield.com>
Cc: Pgsql-Admin@Postgresql. Org <pgsql-admin@postgresql.org>
Subject: Re: NIC to NIC connection
Date: Tue, 19 Oct 2004 19:22:19 -0400 (EDT)
Message-ID: <Pine.LNX.4.61.0410191915480.21329@leda.steelsun.com> (raw)
In-Reply-To: <LPENJIOOLAIJBFKIBDKOAEJHFMAD.kenta@ezyield.com>
References: <LPENJIOOLAIJBFKIBDKOAEJHFMAD.kenta@ezyield.com>
There have been many comments about this already Kent. My $.02:
The most common practice I am aware of is to install 2 NIC's in each
appserver - one to your load balancer, and one to your private network
(192.168.*) where your database server sites. In fact, ideally your
database machine has no publically addressable nic at all. I have
personally dealt with such a setup in several installs, some doing of
millions of page views per *day*, and it has always been very reliable,
secure, and fast.
Use gigabit everywhere on your 192.168 "database" network. If you are
concernced about bandwidth, wire up http://www.mrtg.org and look at the
traffic for yourself.
getting postgres to use this setup should be a piece of cake. Just make
sure your settings in pg_hba.conf are setup right.
Good luck.
On Tue, 19 Oct 2004, Kent Anderson wrote:
> We are upgrading our servers and have run into an interesting situation. It
> has been proposed that we have a direct connection from the web servers to
> the postgres server via extra NICs. Has anyone done this before and how big
> a project would it be to alter ASP and Java applications to make use of such
> a connection?
>
> Before we even waste time installing the NIC's I would like a sense of how
> hard it is to get postgres to use that kind of a connection vs over the
> Internet. We are looking to increase communication speed between the web
> servers and database server as much as possible.
>
> Thanks
> Kent Anderson
>
[ \ /
[ >X< Christian Fowler | spider@viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: spider@viovio.com, kenta@ezyield.com
Subject: Re: NIC to NIC connection
In-Reply-To: <Pine.LNX.4.61.0410191915480.21329@leda.steelsun.com>
References: <LPENJIOOLAIJBFKIBDKOAEJHFMAD.kenta@ezyield.com> <Pine.LNX.4.61.0410191915480.21329@leda.steelsun.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