Handling 10,000 concurrent users

[eluser]ravi kiran[/eluser]
Hi, need to know if it is possible to handle 10000 concurrent user using php-mysql....if so what are the hardware specifications required. will codeigniter solve this purpose.

[eluser]Fr3aked0ut[/eluser]
1000 users? It's depends your host, It's not that much.. Most of the hosts can handle it.

[eluser]ravi kiran[/eluser]
its 10,000 CONCURRENT users..not just users

[eluser]johnwbaxter[/eluser]
CI can handle that if your hardware and your own coding abilities can.

I don't know exactly what hardware you will require (your site could be streaming videos or anything for all i know) but i imagine if you use Something like Amazon EC2 or similar you will be able to scale to whatever you need.

[eluser]ravi kiran[/eluser]
Oh thanks for that..I just want to know what sort of care i should take while handling database(mysql)..any suggestions to optimize performance.

[eluser]pistolPete[/eluser]
If your application is database-heavy, I suggest having a look at memcache.

[eluser]johnwbaxter[/eluser]
There are many things you can do, make sure you're index's are well built and tuned to the sort of queries you will be getting a lot of, definitely look at db caching as pistolPete has suggested as that will make a huge difference to the sort of concurrent users you're expecting.

Also you will want to have a seperate db server to your web server and in fact you may want more than one db server with some load balancing going on.

A bit of googling will turn up a wealth of information on the subject.

[eluser]ravi kiran[/eluser]
Great responses! thanks a ton...i will come back to you if i have more questions..after a bit of research

[eluser]Hickeroar[/eluser]
I definitely recommend looking into something like Amazon EC2 if you're going to have 10k users on your site at the same time. The limitation there isn't CI/PHP/MYSQL, it's server horsepower. You're going to probably pay through the nose for dedicated hosting that can handle that kind of load. At least with EC2 you pretty much have no ceiling and you only pay for the cycles/memory/bandwidth you use.

[eluser]ravi kiran[/eluser]
hey thanks for ur suggestions.