I need to make sure my website is properly optimized (the server, the PHP code, and the MySQL queries) for high traffic. I am getting ready to market my website soon, and expecting a ton of traffic, anywhere from 10,000-50,000 signups in a day which means database intensive, and a lot of image uploads. I need to make sure my server can handle the load.
The PHP code is crappy done by a company off Elance, and I know I have SQL injection problems, and slow queries, so I know that's the first thing to get fixed.
The website is 100% PHP/MySQL, custom framework, a little sloppy done by a company I hired off Elance. It's vulnerable to SQL injections, and also there a lot of slow queries.
I need to get server recommendations on how to setup my servers, RAID, and if I should get a CDN, and how to set it up.
I need a professional who knows databases, servers, security, Linux, and Apache very well. I don't want my website to crash when I begin marketing.
My current server setup is:
Dual quad-core Xeon Server (8 cores)
8 GB DDR RAM
2 x 1 TB 7200RPM SATA hard disk drives
RAID MIRROR
20 Mbit/s unmetered bandwidth
I know it's broad, but my main question is: should I get a CDN to deliver images, or do you think just a beast server can handle the load? Should I use memcache or APC? Etc...
It's a basic social networking niche site, but will have high traffic and TONS of image uploads, and the site is based around images. What kind of RAID if any RAID? What kind of hard disk drives? The company dedicated server I am looking at is pretty affordable and has a lot of options. The server above is only $199/month base. I can add 2 x 600 GB 10k RPM drives for a one time fee of $300, etc...