From: Marcus Bointon
Date: June 26 2009 10:28am
Subject: Re: Upload from cluster takes forever
List-Archive: http://lists.mysql.com/replication/1655
Message-Id: <849A1465-3179-4491-AEC3-4400B0CF9C65@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v935.3)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

On 26 Jun 2009, at 11:21, Xavier Cardil wrote:

> Thank you, I'm using InnoDB. The percona plugin seems interesting,  
> but what
> is the utility in my case ? I'm trying to replicate on a Innodb  
> slave the
> data being entered in to a Mysql cluster system.

XtraBackup can take a consistent snapshot of a running master and  
restore it on a slave, at which point you can start replication and  
have it catch up with the master. Overall it's the lowest-impact way  
of taking a clean copy of a master server. When you say cluster, are  
you referring to a bunch of servers running an existing MySQL  
replication system, or are you actually using mysql ndbcluster?

I'm in the process of writing a rather long blog article on XtraBackup  
- I'll ping the list when it's done, probably next week.

Marcus