Re: Question about hosting

Well for myself I will better like to have the 2 computer design, 1 for httpd and 1 for mysql, it's alway's better that way the few nano that you lose in transit are way better then a server that do both stuff. Now the problem (that eat a lot of time is php and mysql, doh!). So you have optimise that, is mysql will be mostly for read or write data what kind of %, if you need more read or more accurate read then write I suggest you to have a lot of heap table (in memory table, put them read only and get them to regenerate at every x times), copy of the mainly used data in your application, with a lot of ram that will speed-up the main thing. Then an other thing is to take big table and put them in smaller table, way faster for writing/reading (hum, I don't quite remember if mysql is row locking or table locking during write?). Then they other best stuff is to make your dynamic page (.php) and to make them static page (.html) this way you will get way faster viewing page, you don't have they overload of neither php, nor mysql processing. khttpd anyone? Anyway, you could do a lot of stuff, load-balacing, an other server for just your image, ... If you want more, you should go at http://www.slashdot.org/ and do a little search on that subjectthey had a few good article on that on the last few month, year,... Jay Paulson wrote: > > Hello everyone- > > I need some expert advice so I turn you to all! :) > > I'm am currently in the process of making 7 web sites using PHP and MySQL > backend. I'm porjecting that all of these sites combined will get a million > plus hits a month easy when it's all said and done. What I'm wanting to do > is to put the database on it's own machine and put the sites on a different > machine to reduce the cpu load. However, I'm not 100% sure this is the best > option. I know there are a ton of variables to consider with this situation > and I'm trying to figure out the best way to go so I don't have to redo it > again. > > I'm thinking with the traffic these servers are going to incur if they are > on one computer then I should probably have a dual CPU with a gig of ram or > more and two hard drives.. Once CPU for serving up the pages and once CPU to > run the db. Also, one HD for the db and one HD for the pages in trying to > get the most performace out of one machine. > > Some of the dedicated options that people have thrown to me are in the range > of a 450 CPU with 512 Ram and 30GB drive. I don't think that with so many > pages being served that this system will handle it. > > Any suggestions? > > Thanks, > jay > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Francis Fillion, BAA SI Broadcasting live from his linux box. And the maintainer of http://www.windplanet.com