Skip site navigation (1) Skip section navigation (2)

Re: NIC to NIC connection

From: Ben Kim <bkim(at)coe(dot)tamu(dot)edu>
To: Kent Anderson <kenta(at)ezyield(dot)com>
Cc: "Pgsql-Admin(at)Postgresql(dot) Org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: NIC to NIC connection
Date: 2004-10-19 18:50:40
Message-ID: Pine.GSO.4.10.10410191252080.21574-100000@edsun.coe.tamu.edu (view raw or flat)
Thread:
Lists: pgsql-admin
My 2 pence.

I think it's not a big task. If the servers are located nearby, all you
need is.

Connect the two machines: 
=========================== 

- get a crossover patch cable (Should be crossover - you can buy or make
one by googling instructions.) 

- install one extra NIC on each machine and connect the two NICs using the
crossover cable

- give a private address to each NIC so that they share the same internal
network, like 192.168.0.3 and 192.168.0.4.

Change connection string: 
=========================== 

- change the database host in your ASP or JSP database connection file(s)
to this internal address. (For example, jdbc:postgresql://db.some.com/mydb
to jdbc:postgresql://192.168.0.4/mydb.)

If you are using dreamweaver, etc., if you will need to change the
connection setting there too.

In my network a bulk transfer speed through the internal link is not much
better than that of the external link. But the former is significantly
better during a busy day. (But then, the database sessions are more likely
to be interactive type of traffic...)

You also get security as a side benefit. (Data can't be snooped.)


Regards,

Ben Kim
Database Developer/Systems Administrator
College of Education 
Texas A&M University

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
> 


In response to

pgsql-admin by date

Next:From: Richard_D_LevineDate: 2004-10-19 18:51:58
Subject: Re: NIC to NIC connection
Previous:From: Andrew SullivanDate: 2004-10-19 17:58:23
Subject: Re: NIC to NIC connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group