Solved

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

Posted on 2014-04-29
4
483 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 110

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 110

Expert Comment

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

All the best, ~Ray
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
"Go Fund Me" type plugin 5 40
java mysql insert application 14 41
Using Modal's in to Retrieve Data from MySql and Populate Forms 13 77
Concat multiple records into one line 3 40
New Relic: Our company recently started researching several products to figure out what were the best ways for us to increase our web page speed and to quickly identify performance problems that we may be having. One of the products we evaluated wa…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

735 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