List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:March 21 2011 11:44am
Subject:Re: Question about Backup
View as plain text  
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since 2009

Am 21.03.2011 12:23, schrieb Pedro Nuñez:
> Hi
> 
> I need set up a backup strategy  for a mysql database in a ubuntu server,
> the database will grow up to a 5TB.
> What would be the best option ?? Maybe a script that uses mysqldump?? There
> is a better way to do this?
> 
> Thanks in advance to all
> Pedro.

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Question about BackupPedro Nuñez21 Mar
  • Re: Question about BackupReindl Harald21 Mar
    • Re: Question about BackupKaren Abgarian21 Mar
    • Re: Question about BackupJohan De Meersman22 Mar
      • Re: Question about BackupKaren Abgarian22 Mar
        • Re: Question about BackupWm Mussatto22 Mar
Re: Question about BackupKaren Abgarian21 Mar