Solved

Realtime mysql database backup (Magento database) to Amazon RDS

Posted on 2015-02-21
3
498 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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks! I think this is a good plan.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

728 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now