Laurent Kappler a écrit :
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
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
Laurent
