On 24.3.2012 08:43, Jussi Hirvi wrote: > For MySQL backups, I think nobody mentioned doing nightly backups with > mysqldump and then backing them up with rsync or other tools. That is > what I do. No need to stop any services even for a second.
With MyISAM tables, to keep integrity, you might want to read lock the tables. Depending on the amount of data a full dump can take a long time. If you have to write while dumping, you cant, and this is a kind of a stopped service ;-) -- Kind Regards, Markus Falb
signature.asc
Description: OpenPGP digital signature
_______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
