MySQL Hot backup for 60GB database.
First I've read that mysql dump is can be slower than another enterprise app so that is where I'm exploring now.
Trying to find a solution for a hot backup of a 60GB database. It needs to be encrypted because of sensitive data so looking for the software to use, commands, and tips.
MySQL Enterprise Backup - Is what I'm looking at 30 day free trial but cannot find how much it cost?
If I wanted this recoverable up to the closet time like 15 minutes/1hour how can that be acomplished? Which command?
I've also seen Percona XtraBackup 2.4.8 but seems to be Linux based and I would have to spin up and pay for another Linux server. I know the db is small but the nightly backups we take would be bad if I could recover 23 hours ago. I need a smaller window.
Also since the DB is so small is it faster to backup to same server and then have an ftp script send or copy it somewhere else.
The fear is with this application it says there are reasons for a table to become corrupt. So I also won't know the time it does become corrupt is backing up every hour or every change just going to overwrite that? How do I achoomplish the simple goal of Daister Recovery up to the minute of incident. If it is a corrupt table or an entire database that needs to be restored for some reasons.