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


http://www.maatkit.org/tools.html


 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
<marcus@stripped>wrote:

> 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/
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>

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