On Apr 12, 2008, at 16:48, Nathan Schmidt wrote:
Thanks for the tips! We've got a project underway already to move to InnoDB but it's a bit of a hassle (particularly since we really really don't like going offline for maintenance).
Don't you run master-master?Stop replication from A-B, run database traffic on "B", do schema changes on "A", let replication (B-A) catch up, move traffic to "A", restart A-B replication.
Viola. No downtime. - ask -- http://www.askbjoernhansen.com/
