Thread

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.

1000 users? It’s depends your host, It’s not that much.. Most of the hosts can handle it.

its 10,000 CONCURRENT users..not just users

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.

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.

If your application is database-heavy, I suggest having a look at memcache.

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.

Great responses! thanks a ton…i will come back to you if i have more questions..after a bit of research

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.

hey thanks for ur suggestions.

I don’t know what database you are using, or if you are using one, but with 10,000 concurrent users data concurrency could be an issue.

Hi Relexx,
I am planning to use mysql.

Then you need to understand how mysql handles concurrent updates, deletes.  10,000 users, I assume, will significantly increase the chance of the same records being updated.  You definitly want to be looking an InnoDB or Falcon (if using Mysql6).

InnoDB
InnoDB storage Engine
in particular
- Transaction model
- Multi-versioning

Falcon
Falcon Storage Engine

If you are storing credit card details you need to consider standards such as PCIDSS

I am guessing..problem wouldnt be with updates..this site we are planning is mainly about retrieving data..so majority u can say 80% of the users use it to retrieve data

To be exact this will be a business listing directory