Laurent Kappler a écrit :
Albert W. Hopkins a écrit :
On Tue, 2010-01-12 at 15:15 +0100, Laurent Kappler wrote:
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.
One could argue that MySQL isn't a real DBMS too but I won't get into
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.
ok now I see Berkley is a giant Hash table that would need some time to
practice first to find specific use.
So I might have Mysql or you would recommend something else ?
And then instal BDB to experiment.
I searched google for info about configuring a server only for database
but did not find anything relevent.
Where should I look?
Sorry to double post