Solved

Realtime mysql database backup (Magento database) to Amazon RDS

Posted on 2015-02-21
3
531 Views
Last Modified: 2016-03-02
Hey everyone,

I'd like to get a realtime backup (mirror) of our Magento database done off-site. Does anyone have any thoughts on doing this with Amazon RDS?

Has anyone done this before? If so, have you run into any issues?

Our shop does an average of around 50-100 transactions per day but on days where we have new product launches we can spike as high as 2000 (in a 24 hour period... with the bulk coming in the first hour). Would I be able to get away with doing this to a light instance or should I go bigger?

Thanks for any input you can share!
0
Comment
Question by:mcainc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Stuart Scott earned 500 total points
ID: 40628527
I don't believe you will be able to do with this RDS (from my experience).  RDS is a fully managed Database solution, it is not designed to be used as a backup replica of your on premise Database.  However you can move your Database into RDS which will then allow you to implement High Availability of your Databases through the use of different availability zones etc.  The following link will help you in doing so with minimal downtime:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html

You can then implement Read Replicas which will create a real time replica of your Database on another host, this can be used in a fault tolerant design should your primary become unavailable.

As RDS is a fully managed solution is has a host of great built in features allowing Automated Backups – Turned on by default, which enables point-in-time recovery for your DB Instance.   You can also create DB Snapshots – DB Snapshots are user-initiated backups of your DB Instance. These full database backups will be stored by Amazon RDS until you explicitly delete them. You can create a new DB Instance from a DB Snapshot whenever you desire.

Should you look at migrating and moving towards RDS, with regards to instance size, I would start with a size that you think is most appropriate for the size of your database as you can scale up your compute size if required.  As you pay for what you use, its best to start smaller.

Cheers,

Stu...
0
 
LVL 8

Expert Comment

by:Stuart Scott
ID: 40628546
Hi,

Following on from my previous post you could also take a look at the section "How do I import data to Amazon RDS?"  in the following link

http://aws.amazon.com/rds/faqs/

Cheers,

Stu...
0
 

Author Closing Comment

by:mcainc
ID: 40657576
Thanks! I think this is a good plan.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question