Solved

Realtime mysql database backup (Magento database) to Amazon RDS

Posted on 2015-02-21
3
516 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
  • 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

803 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