List:General Discussion« Previous MessageNext Message »
From:Karen Abgarian Date:March 22 2011 5:32pm
Subject:Re: Question about Backup
View as plain text  
Why, if they shut down the slave, it will be quite consistent.  Only that this technique
is not as much of the 21th century, but is like 30 years old.  
Placing locks is about the same as shutting it down. 

On Mar 22, 2011, at 6:01 AM, Johan De Meersman wrote:

> You are assuming that the database is one table of 5.000 gigabyte, and not 5.000
> tables of one gigabyte; and that the backup needs to be consistent :-p
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>> To: mysql@stripped
>> Sent: Monday, 21 March, 2011 12:44:08 PM
>> Subject: Re: Question about Backup
>> 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
> -- 
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

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