Production Ready LAMP Server + Dedicated MySQL Server

In Progress

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 [url removed, login to view] 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: Database Administration, Linux, Magento, MySQL, System Admin

See more: ready lamp, dedicated mysql, lamp server 1gb, ubuntu lamp dedicated database server, production ready lamp ubuntu, lamp server mysql, production experience, mysql expert hourly rate, go web server, at&t help support, app get linux, magento lamp server, set secure production lamp server, rackspace web, rackspace servers, rackspace dedicated server, migration expert, lamp web, lamp app, how to setup a cloud server, vps hosting set up, vps hosting admin, vps cloud, ubuntu server, set up vps

About the Employer:
( 11 reviews ) Bellevue, United States

Project ID: #1419932

14 freelancers are bidding on average $130 for this job

CoVaLiDiTy

magento pro, can help you. tnx.

$100 USD in 1 day
(469 Reviews)
7.5
shakoush2001

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno More

$100 USD in 3 days
(79 Reviews)
6.4
jeeves82

I can help you. Please check PM.

$99 USD in 1 day
(42 Reviews)
6.2
t3nt3tion

I have checked your project details, and I`ve sent you a private message.

$450 USD in 3 days
(23 Reviews)
5.7
virusvi2

I'm ready!

$150 USD in 0 days
(53 Reviews)
5.4
lucarossi

I can help you

$100 USD in 2 days
(32 Reviews)
5.2
hamidnk

we need to append some php tuning to optimize magento landing plz ech my message and evaluate my experience

$50 USD in 1 day
(29 Reviews)
4.8
mjoyner

Should be simple

$100 USD in 1 day
(5 Reviews)
4.6
slk

Please see PMB.

$199 USD in 2 days
(13 Reviews)
4.6
ansura

2 possible solutions: 1. Host App + DB on single server will give you optimum performance but is not recommended for obvious reasons. 2. Host on individual servers but connect App + DB via internal network. Most More

$100 USD in 1 day
(2 Reviews)
4.5
splourde

Hi, I'm a Linux system administrator and I have an excellent experience with these type of setup so I think I'm the most qualified person here to help you!

$100 USD in 20 days
(10 Reviews)
3.7
robinladwal

I hope you find me very useful. Please refer to private message for details.

$100 USD in 0 days
(5 Reviews)
3.2
nadimco

Hello. I have a much better solution for you. See PM please.

$85 USD in 3 days
(3 Reviews)
2.8
satyapalgarhwal

ready to work with you

$150 USD in 1 day
(0 Reviews)
1.8
ehostingtech

I can do it. I have 10+ Years experience to Managing Linux as well as Windows Servers.

$30 USD in 1 day
(0 Reviews)
0.0