0

I have a MariaDB 10.1 master/slave using InnoDB setup running on CentOS 7 which is mostly working as expected. However, somehow the slave has ended up with an extra column in a few tables. This column was deleted on the Master as part of the data import process but that change has not happened on the slave. The column is not required at all so I'd like to delete it.

So my question is (hopefully) simple: Can I safely delete the column directly on the slave without breaking replication?

Many thanks.

asked Sep 13, 2016 at 11:57
1
  • it should be fine. Worse case scenario you have to rebuild the standby. Commented Sep 13, 2016 at 16:08

1 Answer 1

1

yes, you can safely delete the extra column if you are sure it's not in the master.

But the bigger question is why didn't the change carry over to the slave, Any errors when you do a "show slave status" is the "seconds behind master" 0?

You might as well refresh the slave with a newer backup from the master to be sure everything is consistent.

answered Sep 13, 2016 at 21:10
1
  • Many thanks for the answer. No errors and 0 seconds behind master. Commented Sep 14, 2016 at 12:12

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.