At present, I seem to be running out of time and through my research have
come up with the following:
- High bus speed. When you have 2GB of ram or something (needed with
PGSQL, smart with MySQL), bus speed becomes the bottleneck. Any good
processor out there (AMD is new to the SMP market, but supposedly quite
stable... and fast... considering DDR RAM and high bus speeds, Intel is
proven- though P4's are still considered unstable for running a database
server. As well, P3's ABOVE 1GHz ARE NOT GOOD FOR DATABASE SERVERS. Go
with maybe a P3-866 or P3-900.) should do the trick. SMP will be useful as
long as the OS uses it (Linux is a good choice). Web servers will be the
least of your worries. The database server will have no user accounts and
you will probably comment out the whole inetd.conf file, and shut down each
and every daemon. You would have an SSH server and the database ports open-
so keeping really ahead of security is no biggy. Probably a good firewall
rule to block all but internal machines would be useful too.
The databases tend to use a lot more load than the webserver. You
should be okay with something simple for that. PGSQL loads the whole DB
into Shared RAM if possible, so get lots if you use PGSQL, and it makes
MySQL faster, so do it with mysql. A disk good enough to sync regularly is
helpful. You assume speed on most wouldn't make a diff, except for loading.
Databases will be loaded on startup, rather than constant disk activity like
on the web server. So you should be okay with a reasonable HDD.
Good Luck!
--
Mike
----- Original Message -----
From: "Mark Rissmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2001 4:54 PM
Subject: Re: Ultimate DB Server
> Hey guys,
>
> I am also in the same position as this guy. I was wondering if someone
could
> offer up some specs on a server or any good vendors. I will have two
> servers. Both will be linux. One will be a client/server server for data
> entry via the internet and the other will be a web server accessed by php
> via the internet. The databases will be about 400mb estimated for the
first
> year.
>
> Any recommendations or info would be greatly appreciated. (Or things NOT
to
> do) :)
>
> Mark Rissmann
> Drifting Sands LLC
>
> ----- Original Message -----
> From: "Mike Rogers" <[EMAIL PROTECTED]>
> Sent: Sunday, October 28, 2001 9:07 AM
> Subject: Ultimate DB Server
>
>
> > I'm questioning whether anyone has done benchmarks on various hardware
for
> > PGSQL and MySQL. I'm either thinking dual P3-866's, Dual AMD-1200's,
etc.
> > I'm looking for benchmarks of large queries on striped -vs- non-striped
> > volumes, different processor speeds, etc.
> >
> > Any thoughts people?
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
