Production Ready LAMP Server + Dedicated MySQL Server

IN PROGRESS
Bids
15
Avg Bid (USD)
$128
Project Budget (USD)
$30 - $250

Project Description:
OVERALL GOAL:
I am migrating a Magento website from shared hosting to Rackspace cloud servers.

CURRENT SETUP:
I set up a cloud server with 1GB RAM, Ubuntu, LAMP, Postfix, fail2ban, iptables, phpMyAdmin and SSH. I ported the current live site over and got it running as a staging site.

I then set up another 1GB server with just the MySQL database running on it. Everything was running fine in this pre-migration state.

PROBLEM:
I switched the live site’s database to the Rackspace MySQL server (app still on shared host). At first, it was fast. But within 12 hours, pages were taking 25 seconds to respond. I increased the MySQL server to 8GB and tuned my.cnf variables, but the best I could get is the latency down to 10 seconds. So, I pointed the db back to the old MySQL server on the local, shared hosting. Performance instantly returned to normal (~1 second loads).

HELP NEEDED FROM YOU:
Set up a VPS environment (secure, production ready LAMP & MySQL servers) that can host this Magento site with full, fast, verifiable performance.

You can start from scratch or optimize what I currently have. I’ll take your recommendations of whether 2 do servers like described, or everything on 1.

My hope/thought is that a 1GB + 1GB setup would be plenty of power and better than its current shared hosting.

It’s possible that the latency was because the web server was in one data center (New Jersey) while the DB server is in Dallas… and maybe the latency will go away once the website is hosted in the same center.

Magento databases are notorious for needing power and not being optimized. But, it was working fine on shared hosting. So, before heavily optimizing the database, I’d like to first see if we can a new setup with similar performance. If I need to increase RAM amounts, I will, but obviously want to try to get a minimum setup working if possible.

The winning bid will be someone who communicates at least some understanding of what my problem is, how they will solve it, and some indication of their specific experience in this area. Please don’t simply say you’re an expert because that doesn’t help me evaluate you.

Also, please provide your hourly rate if you’re interested in addon support work down the road.

Skills required:
Database Administration, Linux, Magento, MySQL, System Admin
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 1 days
$ 100
in 3 days
Hire jeeves82
$ 99
in 1 days
$ 450
in 3 days
$ 150
in 0 days
Hire lucarossi
$ 100
in 2 days
Hire hamidnk
$ 50
in 1 days
Hire mjoyner
$ 100
in 1 days
Hire slk
$ 199
in 2 days
Hire ansura
$ 100
in 1 days