List:Cluster« Previous MessageNext Message »
From:Adam Dixon Date:June 25 2006 12:14am
Subject:Re: Replication with NDB (under 5.0)
View as plain text  
This is what I did to migrate my live data accross the the cluster. I
didnt have any major issues. I utilized an existing slave so that I
didnt have to adjust operations on the master, eg stop slave on the
running slave host, dump data from the slave, then restore to cluster,
then start slave on both.

Regards
Adam

On 6/24/06, Alex Davies <alex@stripped> wrote:
> Hi Guys,
>
> I'm about to move a rapidly changing database over to NDB. Data loss
> or downtime (or extended locks) are not an option for this DB. Can
> anyone confirm that the following plan will work?
>
> 1) Dump current DB on live machine with --master-data=1 (this machine
> happens to be a replication master)
> 2) Import dump, alter to NDB
> 3) Setup one SQL node as a replication slave; start it
> 4) Wait for the NDB cluster to catch up on all the rows that changed
> since the dump was made (which will be a several hour period by the
> time we have imported the dump)
> 5) Move the application over to the new cluster
> 6) Stop the slave on the new cluster.
>
> I'm going to be doing this in the next few hours, so any comments
> would be appreciated.
>
> Many thanks,
>
> Alex
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster?unsub=1
>
>
Thread
Replication with NDB (under 5.0)Alex Davies24 Jun
  • Re: Replication with NDB (under 5.0)Adam Dixon25 Jun
    • cluster replication in 4.1.16Yong Lee30 Jun
      • RE: cluster replication in 4.1.16Jimmy Guerrero30 Jun
        • RE: cluster replication in 4.1.16Stewart Smith30 Jun
      • Re: cluster replication in 4.1.16Stewart Smith30 Jun
        • Re: cluster replication in 4.1.16Simon Garner30 Jun
          • Re: cluster replication in 4.1.16Stewart Smith30 Jun
            • Re: cluster replication in 4.1.16Simon Garner30 Jun
              • RE: cluster replication in 4.1.16Yong Lee30 Jun
                • RE: cluster replication in 4.1.16Stewart Smith1 Jul