Re: [gentoo-user] Database only server
Neil Walker a écrit : Laurent Kappler wrote: 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 :) So, what you are talking about is a really tiny database. Hmm. You could run that pretty well using a straight text file on an 8 bit computer. ;) If you want scalability for the future, I still think mysql is the best option. Be lucky, Neil http://www.the-workathome.com ...hm..I should install myodbc and use it to remotly request the db server? Be strong, be wrong :) Laurent
Re: [gentoo-user] Database only server
Laurent Kappler wrote: > 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 :) So, what you are talking about is a really tiny database. Hmm. You could run that pretty well using a straight text file on an 8 bit computer. ;) If you want scalability for the future, I still think mysql is the best option. Be lucky, Neil http://www.the-workathome.com
Re: [gentoo-user] Database only server
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
Re: [gentoo-user] Database only server
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
Re: [gentoo-user] Database only server
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.)
Re: [gentoo-user] Database only server
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 ? I think you will find it's more about the disk sub-system than anything else. > Could I do that using only Mysql or is it possible to have Mysql and > Berkley, or should I have just Berkley ... ? My choice would be mysql. It's used for one of the largest databases on the planet - s...@home. ;) Be lucky, Neil http://www.wwseti.us
[gentoo-user] Database only server
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 ... ? Happy new year!! Laurent