<div>
Hi,<br />
<br />
Following on from my previous post you could also take a look at the section &quot;How do I import data to Amazon RDS?&quot; &nbsp;in the following link<br />
<br />
<a href="http://aws.amazon.com/rds/faqs/" rel="ugc">http://aws.amazon.com/rds/faqs/</a><br />
<br />
Cheers,<br />
<br />
Stu...
</div>


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/ [http://aws.amazon.com/rds/faqs/]

Cheers,

Stu...

<div>
Thanks! I think this is a good plan.
</div>


<div>
<div class="content wysiwyg-content">
Hey everyone,<br />
<br />
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? <br />
<br />
Has anyone done this before? If so, have you run into any issues? <br />
<br />
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?<br />
<br />
Thanks for any input you can share!
</div>
</div>


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!

Realtime mysql database backup (Magento database) to Amazon RDS

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Magento is an open-source e-commerce platform written in PHP for e-commerce web sites. Magento employs the MySQL/MariaDB relational database management system, the PHP programming language, and elements of the Zend Framework. It applies the conventions of object-oriented programming and model–view–controller architecture. Magento also uses the entity–attribute–value model to store data.