I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited.
I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup.
I know they are different terms. (And ignoring that a wrong delete statement can delete data in which case replication may not be useful).
All I wish to do is have a zero data loss when there is a database failure. AWS maintains snapshots but that may be few hours old. So there is data loss.
Should I consider setting a DB server outside AWS? Or what? Should I do replication or take regular backup?
Any other strategies that DBAs have in mind?