I have a MySQL database that is about 17GB in size. Right now we don't have a backup for this and I have been tasked to look into backing it up automatically.
I am a software developer myself, not an expert database engineer.
After some research I found out that MySQL has something called MySQL Replication, which will automatically create a backup database on different server.
My concern about this is that if someone accidentally drops a table, or deletes a record, the same will happen on the slave database as well - so that would not serve as a backup.
I need suggestions on what can be done with our MySQL database so that it can be backed up automatically.