Given enough hardware and an appropriately designed application, yes you will be able to scale up as high as you want to go. The big questions are how much money can you spend vs. what performance, stability and fault tolerance do you want out?
You have lots of options - Three or four large smp web servers and a one or two replicated mysql servers in a round robin configuration or dozens of moderately powerful servers running both web server and mysql server with a smart load balancing switch in front. Both have advantages and disadvantages. Partly it depends on how you write the application, how many sql calls per page you make, how many are writes vs. reads. It may also make sense to write it into a multi tiered app, having the web server make calls to a dedicated php app server that in turn talks to the database server. I have ways I like to do things, but it really comes down to what you can afford dollar wise, complexity wise, uptime wise and management wise. Jerry On Fri, 31 May 2002, Justin Felker wrote: > Hello to everyone. This email will probably be quite lengthy so please > bear with me. What I am asking is quite important to me, so I will try to > be as detailed as possible. > > I have spent the last hour pouring over this list's archive. I have found > some great information and a lot of you appear to be quite helpful. I just > want to thank everyone in advance for their help. If I have missed > something obvious or my question is redundant, then please point me towards > the appropriate links and I will read them right away. > > I, along with several other people am starting a business which will depend > heavily on its web presence. Unfortunately, I am in the all too common > position of having to make technical decisions that will have repercussions > on the future well-being of said business, with little to no budget. It is > crucial that the solution I pick, handle what we hope will become a very > large load in the not-to-distant future (whether this happens or not is a > question for another day, heh). To this end, I am very interested in using > the LAMP (Linux+Apache+MySQL+PHP) approach. I have experience with all of > these technologies, but I am definitely not in a position to vouch for > their worthiness for use in a large scale application running beneath a > heavy load. > > To quantify LAMP's ability, is it appropriate for say, sites that generate > on the order of 5 million unique hits per day? If not, where would you > draw the line? At 500,000? Or 1 million? If so, how much higher could it > go possibly? 10 million? 20? > > Keep in mind that we have no problem heavily optimizing the application > (code tweaks, cacheing, etc). > > We looked into and even began development in JSP w/ Tomcat but found Tomcat > to be exceedingly unstable for production use (not that it was ever really > meant for it). And of course, the other available application servers > were well beyond our budget. Also, time constraints have forced us to look > for a faster-to-develop alternative. > > Just a couple of details about the application we intend to develop. It > will be very database intensive (many queries per page) and will also > provide real-time payment support (for which transactions are a must). > > So, what say you? Given all that I have said, is LAMP appropriate? Will > PHP and maybe even more importantly, MySQL be able to scale well? I have > no doubt that MySQL is fast, but just how scaleable is it? Will it die > beneath the kind of loads I have described? > > What would be *most* helpful to me is if you could provide web sites that > exist currently and experience this load and are using LAMP > (http://www.sourceforge.net?). > > I hope you are still with me! Thanks a lot for taking the time to read > this and I would appreciate greatly any help that can provide. > > Thanks. > > Justin > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php