List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:September 22 2009 10:21pm
Subject:Re: borked replication
View as plain text  
On 22 Sep 2009, at 17:39, Andrei F wrote:

> 1) grab a dump of the master (server) database: mysqldump -u -p  
> dbname >
> dbname.sql

This will usually work, but won't always as it doesn't guarantee that  
the data is in a consistent state. This becomes more of a problem as  
your database gets bigger and the dumps take longer (and thus  
opportunities for inconsistency increase). Take a look at Xtrabackup  
which doesn't suffer this problem and is very good for setting up new  
slaves (or rebuilding broken ones), I wrote an article about it:
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/


Thread
borked replicationAndrei F22 Sep
  • Re: borked replicationMiguel Angel Nieto22 Sep
  • Re: borked replicationMarcus Bointon23 Sep
    • Re: borked replicationPankaj Joshi23 Sep
  • Re: borked replicationIan Simpson23 Sep
  • Re: borked replicationAndrej Pintar23 Sep
    • Re: borked replicationAndrei F23 Sep
      • Re: borked replicationapi98424 Sep
      • Re: borked replicationMats Kindahl25 Sep