I'm using Jetbackup for backups. Used it for years. Works really well. I have several sites I want to backup the databases more frequently than once a day. A couple of the sites, there's a lot of things being updated in the database constantly. The most critical one is 1.3GB of data, 2.5 million total rows at this point. I see I did configure an hourly backup some time ago but for some reason I disabled it and can't remember why!
I don't think Jetbackup locks the database when it does the backup. I don't want it to because users still need to use the application during the backup. If worse case I lose an hours worth of updates having to go to the last hours backup, that won't be a catastrophe, much better than losing an entire day's worth of new data. I have a Hot Spare server that I'm using MySQL replication to sync the database but in the event there's a large corruption of the data, the replication is going to sync the corrupt data!
The only solution I can think of is setting up MySQL replication to a third copy of the database but, if possible, put a one hour delay on the replication. But then if the corrupted data isn't discovered within an hour, I'm again in a SOL situation. I'm also concerned about increasing server load doing so frequent of backups (although incremental). Maybe that's why I disabled it?
Thoughts?
I don't think Jetbackup locks the database when it does the backup. I don't want it to because users still need to use the application during the backup. If worse case I lose an hours worth of updates having to go to the last hours backup, that won't be a catastrophe, much better than losing an entire day's worth of new data. I have a Hot Spare server that I'm using MySQL replication to sync the database but in the event there's a large corruption of the data, the replication is going to sync the corrupt data!
The only solution I can think of is setting up MySQL replication to a third copy of the database but, if possible, put a one hour delay on the replication. But then if the corrupted data isn't discovered within an hour, I'm again in a SOL situation. I'm also concerned about increasing server load doing so frequent of backups (although incremental). Maybe that's why I disabled it?
Thoughts?
Last edited by a moderator: