Hello there,
My name is Dr. Hitesh Sharma. I have been working as a Project manager and Solution Architect for Woolovers ltd., UK for the last 8 years.
Woolovers is a very big eCommerce website in UK and 8 other countries. I have created and managing their websites and the complete team for last 8 years and the sites have grown now too much that they are now managing more than 1.3 million customers. We have managed all the areas of development, design and SEO for them.
I am not telling you this to brag by any means. I am just demonstrating my ability to help you.
Woolovers is also using MySql database hosted on Linux server and face almost same amount of traffic your web-site is facing during peak times.
I managed to optimize MySql server for handling such a heavy traffic by optimizing tables, queries and applying cache tools on server. Although MySql has it's own query limits but if proper maintenance procedures are followed than it can handle good amount of queries.
Looking forward to work for you!
Thanks & regards
Dr. Hitesh Sharma
“Treat your customers like they own you. Because they do!”