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.
