Solved

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

Posted on 2014-04-29
4
465 Views
Last Modified: 2016-03-24
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
Comment
Question by:lthames
  • 2
  • 2
4 Comments
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 40030816
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
 

Author Comment

by:lthames
ID: 40030825
Thanks!
0
 

Author Closing Comment

by:lthames
ID: 40068665
Thanks.  I contacted phparch and they are going to do some work on it when they get back from the php conference.
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 40068700
Great choice!  You're in good hands with those guys!

All the best, ~Ray
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Using Quotation Marks in PHP This question (http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28217211.html) seems to come up a lot for developers who are new to PHP.  And it got me thinking, "How can we explain the rule…
Thoughout my experience working on eCommerce web applications I have seen applications succumbing to increased user demand and throughput. With increased loads the response times started to spike, which leads to user frustration and lost sales. I ha…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now