Realtime mysql database backup (Magento database) to Amazon RDS
Posted on 2015-02-21
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!