I have a Master/Slave replication.
I had to change the name of one of my columns in one of my tables from
sent_at, this column is not being used yet.
I've issued an
alter table on an unused slave in order to change the column name with hope that once the change will finish. I would be able to use this slave (with the desired column name) as a new master.
The thing that I didn't take into consideration is that once the
alter table is finished that replication will fail since the query that inserts data into the altered table expects the old column name (
temp_col) even if its just inserting null values into it.
Since the alter table took some time, there are a lot of these kind of queries.
- Is there something i can do to repair the replication?
- How can I tell the slave to "ignore" the old column name?