Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Realtime mysql database backup (Magento database) to Amazon RDS

Posted on 2015-02-21
3
Medium Priority
?
619 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

772 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