We have a Java application that periodically backs up a database and an image folder. This application needs to be installed onto a new server as we have moved to AWS.
This application utilises Java, YML, XML, and some shell script.
The application has a master-slave MySQL configuration and backs up are made from the slave server. I think this is because data cannot be written to MySQL when it is being backed up.
The application uses XtraBackup to create incremental backups.
We would also like to understand more about how backups can be restored and have the steps added to the [login to view URL] file.
Also we would like the application to be extended by adding a email notification of the backups activity for each day. Also letting us know that the application is still running correctly.
We would also like help creating additional user for MySQL with permissions that do not allow deletion of data.