Re: your advice on backup procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux