[Tutorial] Step by Step guide to build the Poor Man’s Backup System

[MartinHBramwell]

@bkm

However, I would not recommend running this process any more frequent than every 15 minutes. Running backups does put a strain on the system when it is heavily used. You will have to balance that yourself.

@bkm

If you are really smart, you will also have another place on the internet where you can send copies of your backup files for safe keeping.

If you go the route of having a second server somewhere, you would neither need backups 4 times an hour nor risk losing even a few minutes of user work if you opted for Master Slave replication.

Concerning brown outs.
Whenever there are network failures any updates on the master are not reflected to the slave. When connection resumes, the slave quickly catches up to the right position in the log file and everything is good again.