I am looking for the best way of implementing a Multitenant App in AWS. Imagine I am an eCommerce business that has several eCommerce clients and those clients have other clients that are the ones that buy articles.
The easiest multitenant solution would be to have a single database with shared tables such as Articles where there ir a tenantID column to identify the different clients.
However, in case one of my clients remove some articles accidentally and want to restore to an earlier point of time, it would be a hard process because its data is not in a separate database.
I have tried implementing the solution of one Database instance and multiple databases within it in Amazon RDS but it turns out it does not allow me to restore databases withing the DB instance, it only allows to restore the whole db instance.
What would you recommend me to do? Is there another way in AWS or is it better to have an own dedicated server in this case with separated databases?