What's the max concurrent connections to MySQL database?
I have a friend and he's currently in the progress of preparing online ticket reservation website (PHP site) for local events, and he's already met with prospectus client/organizer who wanted to offer 10,000 tickets for their event.
The online ticket reservation will be opened for about 1 month or so for that event.
Assuming 10,000 tickets to be offered in 1 month. That would be 300-400 tickets a day in average. Well it could be vary, maybe 1000, 2000 or perhaps 3000 tickets in 1 day.
He asked me these questions, but I couldn't give the proper answers, maybe WHT friends could:
1. What if customers hit the website to reserve and buy tickets at the same time? can MySQL handle such large requests (2,000 - 3,000 tickets reservation in a day/at the same time/concurrently)? My friend really worries about this.
2. What's the maximum concurrent connections to MySQL database can be handled?
3. The website is currently hosted on Shared Hosting server. Shall my friend move on to Dedicated Server? or VPS maybe? or is it okay to stay on Shared Hosting?
This thread would probably obtain more replies in a different forum here, such as Programming Discussion. You might want to ask the moderators to move it? The Lounge is never quite as good for this kind of question.
Concerning your questions, especially questions #1 and #3, just note that actual experiences can often differ greatly from expectations. Sometimes you brace for 5000 concurrent connections, then you find that you never really exceed a much smaller number. :p
Mike G. - Limestone Networks - Account Specialist Cloud - Dedicated - Colocation - Premium Network - Passionate Support DDoS Protection Available - Reseller Program @LimestoneInc - 877.586.0555
>>1. What if customers hit the website to reserve and buy tickets at the same time? can MySQL handle such large requests (2,000 - 3,000 tickets reservation in a day/at the same time/concurrently)? My friend really worries about this.
Yes, Mysql is known to handle most complex concurrency issues.
>>2. What's the maximum concurrent connections to MySQL database can be handled?
There is a no maximum as such . It also depends on how much your server specs can take, which is dependent on the apache config, cpu , memory etc.
>>>3. The website is currently hosted on Shared Hosting server. Shall my friend move on to Dedicated Server? or VPS maybe? or is it okay to stay on Shared Hosting?
Depends on the current traffic. He should not reach a situation where he is thrown out of the shared server due to excessive usage of cpu/memory/disk
Sam Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management Spiralbean.com - Custom Software Development
Email: exec @ activelobby.net | Skype: unni_active
Thanks Mike I didn't know where to post such questions above (so I picked the Lounge - which was wrong) Thanks to mod/admin who moved it.
Yeah, the concurrent connections can be vary from time to time, just worried if there will be 5000 concurrent connections and the server (especially shared hosting) can't handle it.
Thanks to you (activelobby4u) too for the answers
Well, I think I will let my friend to move on and try how it goes. If the server is unstable (and the host provider gives a warning), I'll tell him to upgrade from his current Shared Hosting to VPS or maybe Dedicated Server.
Keep in mind that 5,000 vistors hit your site in a second would typically only be about 500 concurrent connections, assuming your transactions take 0.1 seconds. Shared hosting may be perfectly fine, but I'd go for a "business" hosting plan, rather than a cheap $3/month plan at the very least.
If thousands of dollars of revenues are at stake, I wouldn't take the risk I'd go for a fully managed dedicated server or VPS.
How much money will be lost if your shared hosts shuts down your site for 6 hours on a busy day?
Dallas Colocation by Incero
e: sales(at)incero(dot)com • 855.217.COLO (2656)
Colocation & Enterprise Servers, SATA/SAS/SSD, secure IPMI/KVM remote control, 100% U.S.A. Based Staff
SSAE 16, SAS70, Redundant Power & Network, Fully Diverse Fiber
@gordonrp : yeah, my friend aware and has anticipated it not to go with 'cheap' web hosting plans. He chose the local hosting provider (the "premium business" shared hosting plan which costs around $18/month).
He was just worrying and wondering if his current shared hosting (both server and MySQL service) couldn't handle such large requests (to sell 10,000 online tickets reservation) - He wasn't expecting that large, previously he thought that he would get client who wanted to sell around 100-1000 tickets).
Well. I'm sure his customer(that event organizer) would be mad and might sue him for the failure, and he could lost a lot of money if there's a problem/issue with the server (such as: host provider shuts down for 6 hours/whole busy day).