List:Cluster« Previous MessageNext Message »
From:Alex Davies Date:June 24 2006 9:59am
Subject:Replication with NDB (under 5.0)
View as plain text  
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
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