List:Replication« Previous MessageNext Message »
From:Pankaj Joshi Date:September 23 2009 5:53am
Subject:Re: borked replication
View as plain text  
Apart from setting the fresh slave you can use this tool to check the
consistency between the master and slave on periodic basis

mk-table-checksum from maatkit

 this tool will give you the details of the table which are not in sync
.once you know the tables you can use

Mk-table-sync to sync the data between the master and slave

Pankaj Joshi**

On Wed, Sep 23, 2009 at 3:51 AM, Marcus Bointon

> 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:
> Marcus
> --
> Marcus Bointon
> Synchromedia Limited: Creators of
> UK resellers of info@hand CRM solutions
> marcus@stripped |
> --
> MySQL Replication Mailing List
> For list archives:
> To unsubscribe:

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