Re: [gentoo-user] Database only server

[Laurent Kappler <laurent@logiquefloue.org>]

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