We help IT Professionals succeed at work.
Get Started

Magento & Amazon RDS

mcainc
mcainc asked
on
244 Views
Last Modified: 2016-05-23
Hey guys,

We have a Magento shop with some dedicated hardware that we use for both the web application and database. What I'm considering doing is keeping our web application on our own hardware but offloading the database to Amazon RDS.

Even with local replication and daily backups, I'm worried about losing data in the event of some failure. Compound this by the fact that we were just looking through some old database backups and found out that a lot were corrupted. Definitely scared me straight.

So my question is, does anyone think this could create a huge performance hit? I know EC2 to RDS would be ideal but we have a lot invested in hardware and need to continue using it for the time being.

Beyond that, the only other concern I have is the availability of it. I'm a little confused at the pricing and know that most of the time our database runs relatively low on resources... we do maybe 50-100 transactions per day and use very little CPU. However, on new product launches we can do over 1000+ transactions in a 1 or 2 hour period.

My biggest concern is that I don't want the RDS instance I select to hit a ceiling and create issues when spikes like this occur.

Am I misunderstanding something? Can our RDS spike into just about any level of CPU usage without affecting performance (and only increasing my bill)?

Hopefully that makes sense! Thank you for your time!
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE