new to RBR and am wondering how to remove a column in the middle of a table in an active-passive setup without breaking replication? Pre-RBR I would just have run the alter on one side and then failover writes. Running Percona 5.6 server in a scaled out environment.
ALTER will go through RBR, so I don't see it as being much different.
As long as
- you don't do
SELECT *, the fetches should remain OK.
- no queries touch the column you are removing any time near the action, write queries should not be an issue.
If you are trying to avoid the table being blocked a long time, I see some use for the 'failover' you mentioned (but did not adequately detail).
What version do you have? 5.6 rebuilds "in place" and permits concurrent DML. So, the 'failover' may be overkill.