What scripts are the most popular these days for virtual hosting users to periodically back up MySQL data? The total size of all my MySQL tables is about 1 GB. I haven't backed up my tables in a long time, but I remember the last time I did it, it was a long process that lasted several hours,. The worst thing was that during that time my CGI scripts that were supposed to work with MySQL tables didn't work. What software would you recommend to minimize the back-up time?
Unlock mode .. means allow the system to write the backup even whent he backup is being done. This means, your backups will be done, while new data/changes are written to the database.
the default is not to lock the database for changes while the backup is being made. If your data keeps growing, and if absolute backups are not a must, you can use the unlock mode and get a working data. Resources wise, rsync will use less resource than mysqldump.
How often do you want to backup the database . If once a day, a cron at off-peak time of the server will be fine.
Experienced OpenStack Admin For Hire
regular as admin0 on freenode IRC on #openstack and #openstack-ansible channels