We're an online store and backups are made daily. The problem is that if our database is lose, we lose all database changes/orders that were made on our site that day. We're tossing around the idea of setting up a database instance on Amazon and saving a copy of all customer's order information there as well so if our database went down we'd have that in place as a backup and not actually lose any customer information.
This seems like a decent solution, but are there better options available for syncing databases? One thing I don't like about this is that it requires adding extra queries to ensure the databases are synced.
The final factor is that we're moving from our own server to Amazon's cloud hosting for all of our web sites in the next few months. Is having a separate database instance worth it in the long run, would we still need it when we're hosting with Amazon?