| 1 |
Laurent Kappler a écrit : |
| 2 |
> Albert W. Hopkins a écrit : |
| 3 |
>> On Tue, 2010-01-12 at 15:15 +0100, Laurent Kappler wrote: |
| 4 |
>> |
| 5 |
>>> Hi, |
| 6 |
>>> |
| 7 |
>>> I'm looking for some information about the configuration for a |
| 8 |
>>> server used only for a huge database. |
| 9 |
>>> I guess dépendanding on which database server used Mysql or Berkley |
| 10 |
>>> the hardware should not be same. |
| 11 |
>>> Or is it all about having a lot of RAM ? |
| 12 |
>>> |
| 13 |
>>> Could I do that using only Mysql or is it possible to have Mysql and |
| 14 |
>>> Berkley, or should I have just Berkley ... ? |
| 15 |
>>> |
| 16 |
>> |
| 17 |
>> Could you do *what*? |
| 18 |
>> |
| 19 |
>> Do you mean Berkely DB? Berkely DB isn't really a DBMS. It's more of a |
| 20 |
>> flat-file database. It's not even relational, it's key->value based. |
| 21 |
>> |
| 22 |
>> http://en.wikipedia.org/wiki/Berkeley_DB |
| 23 |
>> |
| 24 |
>> One could argue that MySQL isn't a real DBMS too but I won't get into |
| 25 |
>> that ;-) |
| 26 |
>> |
| 27 |
>> Anyway it's very difficult to answer your questions without knowing what |
| 28 |
>> your requirments are (how large is "huge", how many simultaneous users, |
| 29 |
>> anticipated queries/sec etc.) |
| 30 |
>> |
| 31 |
>> |
| 32 |
>> |
| 33 |
>> |
| 34 |
> :) |
| 35 |
> I would like to know more about a configuration with Two servers one |
| 36 |
> for DB and one for Apache. |
| 37 |
> I would have no idea of the number of request right now, I would like |
| 38 |
> to set up a scalable small structure first. |
| 39 |
> But there might be from 5 to a 100 e-commerce application with like |
| 40 |
> between 20 and 5000 products...so it can be small but it can looks |
| 41 |
> huge to me :) |
| 42 |
> |
| 43 |
> For me Berkley DB was all loaded in RAM and those been very fast. |
| 44 |
> Even experimental I would like to set up something performant. |
| 45 |
> |
| 46 |
> thx ;) |
| 47 |
> Laurent |
| 48 |
> |
| 49 |
> |
| 50 |
> |
| 51 |
> |
| 52 |
ok now I see Berkley is a giant Hash table that would need some time to |
| 53 |
practice first to find specific use. |
| 54 |
So I might have Mysql or you would recommend something else ? |
| 55 |
And then instal BDB to experiment. |
| 56 |
I searched google for info about configuring a server only for database |
| 57 |
but did not find anything relevent. |
| 58 |
Where should I look? |
| 59 |
|
| 60 |
Sorry to double post |
| 61 |
Laurent |
Archives