I didn't have time to read this in detail, but have a look at MMM for
MySQL: http://mysql-mmm.org. It might do what you are looking for.
On Tue, Sep 29, 2009 at 01:22, Marcus Bointon <marcus@stripped> wrote:
> On 28 Sep 2009, at 18:58, Chris Kantarjiev wrote:
>> Any bright ideas or tools I've missed?
> Why not make t the master while a is out of commission? It should already
> contain all the data from a, so no need to move anything.
> When you get your new box, initially set it up as a slave, then set up
> circular replication, then switch your clients to the new master (and break
> circular replication if you want to).