Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

Can mySQL handle an ultra-high traffic database application with proper hosting?

Greetings,  I have been tasked with a relatively simple ecommerce application that I would like to use mySQL for.  It is a simple process, about 10 products and a simple checkout process using Authorize.net or paypal for payment.

The only issue . . . . the customer believes they will experience periods of extremely high traffic, like around 1 million visitors in particular 24 hour periods.   I have no idea if they are right about this or not.

Can mySQL handle this?  And any advice on special considerations for an app that could potentially have this much traffic?

Thanks!
0
lthames
Asked:
lthames
  • 2
  • 2
1 Solution
 
Ray PaseurCommented:
Yes, MySQL can handle this.  But you need expert advice when you work "at scale."  Normalization tends to go out the door and it gets replaced by hardware.  Suggest you contact the crew at PHP Architect:
http://www.phparch.com/

In particular, you might want to retain Eli White during the design phase.  He is not inexpensive, but your investment in his knowledge will pay off a hundredfold later, I promise!  He's smart and gets things done.
https://twitter.com/EliW
0
 
lthamesAuthor Commented:
Thanks!
0
 
lthamesAuthor Commented:
Thanks.  I contacted phparch and they are going to do some work on it when they get back from the php conference.
0
 
Ray PaseurCommented:
Great choice!  You're in good hands with those guys!

All the best, ~Ray
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now