We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B).
We have a new MySQL 5.5 instance on another Windows Server 2008 R2 x64 machine (Server C).
I want to replace Server A with Server C.
My plan is to set up Server C as another slave to Server A by 'cloning' Server B like this:
After that I plan on doing this:
After that I want to change Server B's master to Server C.
Is this a viable approach? Are there caveats? May there be any compatibility issues when setting a MySQL 5.5 instance as slave to a MySQL 5.1 instance?
I can't just stop everything and use
mysqldump since there can be no downtime and we have ~25 GB of data that must be transferred over a Gigabit LAN.