Solved

Realtime mysql database backup (Magento database) to Amazon RDS

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

Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

Question has a verified solution.

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

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.
Or at least that’s the word according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering. According to the blog, AWS is launching their AWS MS program to expedite the adoption of cloud by Fortune 1000 and Global 2000 companie…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

635 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