MySQL Forums
Forum List  »  NDB clusters

Re: using cluster as slave
Posted by: Adam Dixon
Date: December 14, 2006 03:59PM

Yes, This is how I migrated our dataset. Just like normal replication really, just setup only 1 mysqld in the cluster to act as a slave, and away you go. Obviously depending on your application will dictate your migration stratergy.

I think I locked all tables for reading only, took a full dump, then noted master log pos etc, unlocked tables, restored dumps to cluster over a period of time (this took a fair time) connected slave with log pos info, start slave, catchup!

Adam

Options: ReplyQuote


Subject
Views
Written By
Posted
1417
December 14, 2006 12:02PM
Re: using cluster as slave
1030
December 14, 2006 03:59PM
861
December 14, 2006 05:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.