List:Cluster« Previous MessageNext Message »
From:Stewart Smith Date:March 24 2010 11:44pm
Subject:Re: Replication from a cluster
View as plain text  
On Wed, 24 Mar 2010 10:36:46 +0100, Hartmut Holzgraefe <Hartmut.Holzgraefe@stripped>
wrote:
> Stewart Smith wrote:
> > The first challenge is getting the data there though. Typically, when
> > setting up a slave that's running NDB you can use ndb_restore to get to
> > a known state. Not so with innodb as the slave. 
> 
> This can be worked around by taking and restoring a schema-only dump
> using mysqldump (make sure ENGINE=ndb is either changed to innodb
> in the dump file or InnoDB is the default engine on the restore side
> and ndbcluster is not available there), and then using
> 
>    ndb_restore --print-data ...
> 
> and LOAD DATA INFILE to restore the actual data?

There is something in the back of my mind on if this processes the log
entries in the backup as well as the data.....

-- 
Stewart Smith
Thread
Replication from a clusterCandice Savino17 Mar
  • Re: Replication from a clusterpetya17 Mar
    • Re: Replication from a clusterStewart Smith24 Mar
  • RE: Replication from a clusterAndrew Morgan17 Mar
  • Re: Replication from a clusterStewart Smith24 Mar
    • Re: Replication from a clusterHartmut Holzgraefe24 Mar
      • Re: Replication from a clusterStewart Smith25 Mar