17 Nov
2013
17 Nov
'13
7:36 a.m.
Hi,
so the backup does need 2 hours? How big is our database?! Thats very,
very long...
A first idea would be mysqlhotcopy, which does the locking etc. for you -
and copy the raw database files (instead of making sql-files which can
take ages). Informations are under
http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy.html . It can do
things e.g. skipping the index files which can be rebuilt, flush the logs
etc.
Another approach is using a lvm under the database-files. This way you get
at least a consistent version which are on the HDDs. Yes, you loose all
information which are only in the RAM, but that shouldn't be too much -
und if you need to replay backups you loose always by average 12 hours -
so 5-10 minutes more ore less aren't that important ;)
Best regards,
Michael Fritscher