Solved

How Much Performance Gain Will Gigabit between Webservers and Database Servers Buy?

Posted on 2004-08-04
4
229 Views
Last Modified: 2010-04-11
Hi,

We are in the process of upgrading our network and due to the firewall being 100mbs/port, we are weighing our options.  Our clients have an Excel add-in that uses webqueries to pull possiby large amounts of data (for those unfamiliar with webqueries, just think of a very large webpage - say at most 5000 rows and 30 columns of comma delimited data).  Besides standard webpage requests we get, say at most, 300 of these high data requests a day.

Do we sacrifice security somewhat and buy one gigabit switch and put the database server and webservers in our trusted zone of our firewall?  The thought being the the webservers will communicate directly to the database server (gigabit connection) before it has to go out through the firewall at 100mbs to the internet.  Alternatively, we could put the webservers in the DMZ. but then they will be limited by the firewall since they will have to go down to 100mbs to communicate with the database server in the trusted zone.  How much does this impact a large request since it still has to go back out through the firewall but then limited further by a 3mbs connection out to the internet?


Thanks,

Karl
0
Comment
Question by:karlkawano
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
fatlad earned 250 total points
ID: 11723976
If your Internet link is 3Mbs there is no way to get information on the web quicker! The internet link will be the bottleneck. Your best bet would be to increase that link, assuming the majority of your requests come from there. It may be more cost effective to get a hosting company to take your servers as they will be able to get massive bandwidth cheaper than you.

If you ever get over 100Mb Internet link, or you have a large number of requests orginating in the LAN, then maybe get a better firewall, one with GigE ports. Checkpoint or PIX can both accomodate this on the higher end boxes. If you are running SCSI HDD in the server remember you will not get a higher transfer rate than the bandwidth of the SCSI bus.

NEVER put the webserver in the trusted network, that is not going to be a good plan. There is no reason why you could not put a GigE Switch entirely in the DMZ although the performance benfits of this will be quite low.

Hope this helps,

FatLad
0
 

Author Comment

by:karlkawano
ID: 11763809
Thanks FatLad,

You pretty much confirmed what I had thought.  Just out of curiousity, any rough idea what the bandwidth is of 15000 rpm drives in a raid 5 configuration?  I have heard that 7500 rpms are roughly 250 mbs, though that was just something I found on a forum.

Thanks again,

Karl
0
 
LVL 3

Expert Comment

by:fatlad
ID: 11771181
Karl,

There are two main things that will effect this:

1. The physical speed with which the disks can pull date from the spinning platters; and
2. The bandwidth of the bus you are using (wide, ultrawide, SCSI160, SCSI320, FC etc).

When you get over 4 or 5 drives it is normally the latter that comes into play as the way data is stripped accross the array means the drives are ready and waiting by the time their turn comes.

Does that answer your question?

FatLad
0
 

Author Comment

by:karlkawano
ID: 11773225
Yes it does, I'll find out what SCSI we have and look the specs up.  

Thanks very much for all the help!!!


Karl
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Suggested Courses

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question