I am migrating a Magento website from shared hosting to Rackspace cloud servers.
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.
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.