[CentOS] your advice on backup procedure

Markus Falb markus.falb at fasel.at
Sat Mar 24 04:23:23 EDT 2012


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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 307 bytes
Desc: OpenPGP digital signature
Url : http://lists.centos.org/pipermail/centos/attachments/20120324/53366bed/attachment.bin 


More information about the CentOS mailing list