mcainc
asked on
Realtime mysql database backup (Magento database) to Amazon RDS
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I think this is a good plan.
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...