Replication and Online DDL

MySQL & MariaDB Other MySQL® Questions
1

Hello!

Is it possible to utilize my replication for runnig online DDLs?

(That is - to allow updates while ALTER TABLE is running)

My replication:

I’m using MySQL replication for high availability.

My topology is such:

  1. Two servers.
  2. Bidirectional replication (The two servers acts both as master and as slave to one another).
  3. Failover: One server is active for the application, the other is completly passive (No reads/writes).

Thanks )

2

http://www.mysqlperformanceblog.com/2008/03/27/using-mmm-to- alter-huge-tables/