From: Marcus Bointon
Date: June 26 2009 11:06am
Subject: Re: Upload from cluster takes forever
List-Archive: http://lists.mysql.com/replication/1658
Message-Id: <6A277575-4619-4710-BDE9-C3B6C0B4AF78@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:36, Xavier Cardil wrote:

> I'm refering to a mysql cluster, using ndbcluster. Will it work that  
> way  ?

Hm. Probably not. Far as I'm aware, ndbcluster doesn't offer any means  
of doing backups outside of an SQL dump (you can't copy the files  
because they are spread across the cluster), so you should probably  
persevere.

As you're using InnoDB, ignore what I said about key_buffer, and like  
ewen said, sort out your innodb config, in particular set  
innodb_buffer_pool as big as your machine will take.

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/