Is it possible to utilize my replication for runnig online DDLs?
(That is - to allow updates while ALTER TABLE is running)
I’m using MySQL replication for high availability.
My topology is such:
- Two servers.
- Bidirectional replication (The two servers acts both as master and as slave to one another).
- Failover: One server is active for the application, the other is completly passive (No reads/writes).