Replication / Migration to MySQL 5.x
Posted on 2006-11-04
I have 2 servers.
1 server is running MySQL 4.x in production.
I want to install 5.x on both servers, get replication working and then Migrate the databases over to 5.x.
At first I thought I was going to be able to shutdown 4 copy over the files to the 5.x directory and it would replicate but that is not the case because there would be no bin log for it to replicate on server 2.
So I was thinking the best way to do this would get replication working. Then
1. Shut down all instances of MySQL.
2. Copy the Databases into the 5.x mysql data directory,
3. then copy them to the server 2 Mysql 5 directory
4. then restart 5.x instances of MySQL and replication would be up and running from server 1 to server 2
Does this sound right? Is there an easier way?
I need downtime to be a complete minimum that is why I want to do it this way.