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
>
>
