I have moved into RDS MYSQL 5.6 and now I have a problem. I have 5 read replicas and a/z master.
I am trying to alter a table and want to change a column value and also on some tables I want to add a new column. Although this operation is non blocking on MYSQL 5.6 but when it gets replicated to the slaves it causes slaves to lag for entire duration of it, I cannot afford slave lag as we are 24/7 operations.
I tried doing SET sql_log_bin = 0; to skip the query to the slave but RDS do not allow this, otherwise I could have done slave (one each) --> master approach and eventually changing on master.
Anyone has any advise how to go on about this in RDS MYSQL 5.6