Php – How many concurrent connection can MySQL+Php server take

mysqlphp

Can it support a small business? Do people recommend MySql + Php set up or a Java server to support a business with say 2000 editors accessing the data at the same time?

Best Solution

MySQL and PHP are very scalable if that is what you're asking. But whether a server can support 2000 concurrent users or not largely depends on the hardware. Additionally, a poorly written application in any language can significantly increase the load on the server.

Sites/companies that use MySQL:

  • Baidu
  • Wikipedia
  • del.icio.us
  • Digg
  • Facebook
  • Feedburner
  • Flickr
  • Freshmeat.net
  • Friendster
  • LinkedIn
  • LiveJournal
  • Photobucket
  • Slashdot
  • StumbleUpon
  • Twitter
  • YouTube
  • YoutSendIt
  • Hot or Not
  • 37 Signals

Sites that use PHP:

  • Facebook
  • Photobucket
  • Wikipedia
  • Yahoo!
  • Digg
  • Friendster
  • SourceForge
  • Flickr
  • Imageshack
  • Wordpress.org

Edit:
There are much better (more important) criteria for picking a development platform than the maximum number of connections it can support. Unless you have severe hardware restrictions and absolutely need to squeeze every ounce of performance out of your server, it doesn't really make sense to choose one over the other for this reason. All of the major RDBMS and scripting languages have reasonable performance and scale quite well. You'll find all of them being used in organizations, and on applications, of all sizes.