List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:August 12 2010 4:04pm
Subject:Re: InnoDB table replication
View as plain text  
On 12 Aug 2010, at 17:51, Julian Rawcliffe wrote:

> I'm using --master-data --single-transaction; I don't know if this
> could be the problem now.

FWIW, I use xtrabackup for building slaves, never had a problem with it, other than that
the latest 1.3 build doesn't work on Ubuntu Lucid, but the 1.2 binaries are fine. I wrote
a blog on it a while ago:
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html

The backups take a long time, but restores are really quick, and it's more reliable than
mysqldump. Because it back up the whole server, not just one DB, I've never had any
trouble with users.

Marcus
Attachment: [application/pkcs7-signature] smime.p7s
Thread
InnoDB table replicationJulian Rawcliffe11 Aug
Re: InnoDB table replicationJulian Rawcliffe11 Aug
  • Re: InnoDB table replicationmartín arrieta11 Aug
    • Re: InnoDB table replicationJulian Rawcliffe11 Aug
      • Re: InnoDB table replicationPrabhat Kumar11 Aug
        • Re: InnoDB table replicationDatabase System11 Aug
      • Re: InnoDB table replicationRick James11 Aug
        • Re: InnoDB table replicationJulian Rawcliffe11 Aug
          • Re: InnoDB table replicationRick James12 Aug
          • Re: InnoDB table replicationDatabase System12 Aug
            • Re: InnoDB table replicationJulian Rawcliffe12 Aug
              • Re: InnoDB table replicationMarcus Bointon12 Aug
Re: InnoDB table replicationJulian Rawcliffe13 Aug
Re: InnoDB table replicationJulian Rawcliffe13 Aug
  • Re: InnoDB table replicationRick James17 Aug
    • SUMMARY - InnoDB table replicationJulian Rawcliffe18 Aug