On Sun, Jul 25, 2010 at 12:55 PM, Geoff Galitz <ge...@galitz.org> wrote: > > Hello. > > I need to migrate a master and slave to new hardware. The DB is approx 50G > on disk and my time window for downtime is approximately 4 hours. > > My question is, is it advisable to do a mysqldump from the old master and > then load on the new master and slave, or is it faster to just set the new > master up as a slave, and when it catches up to the old master I "flip the > switch?" The catch is that the new hardware is in a different datacenter. > > In other words, which is faster: dump and load or replication over the > Internet? > > Thanks for your time. >
There may be significantly better options available to you. What version are you coming from and what version are you to? What engines do you use (Innodb, MyISAM,etc)? Is the data directory currently mounted on a lvm volume? -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
