Albert W. Hopkins a écrit :
On Tue, 2010-01-12 at 15:15 +0100, Laurent Kappler wrote:
Hi,
I'm looking for some information about the configuration for a server
used only for a huge database.
I guess dépendanding on which database server used Mysql or Berkley the
hardware should not be same.
Or is it all about having a lot of RAM ?
Could I do that using only Mysql or is it possible to have Mysql and
Berkley, or should I have just Berkley ... ?
Could you do *what*?
Do you mean Berkely DB? Berkely DB isn't really a DBMS. It's more of a
flat-file database. It's not even relational, it's key->value based.
http://en.wikipedia.org/wiki/Berkeley_DB
One could argue that MySQL isn't a real DBMS too but I won't get into
that ;-)
Anyway it's very difficult to answer your questions without knowing what
your requirments are (how large is "huge", how many simultaneous users,
anticipated queries/sec etc.)
:)
I would like to know more about a configuration with Two servers one for
DB and one for Apache.
I would have no idea of the number of request right now, I would like to
set up a scalable small structure first.
But there might be from 5 to a 100 e-commerce application with like
between 20 and 5000 products...so it can be small but it can looks huge
to me :)
For me Berkley DB was all loaded in RAM and those been very fast.
Even experimental I would like to set up something performant.
thx ;)
Laurent
