Hi we have 2 servers 1 master 1 slave
the master 5.5.42-cll MySQL Community Server the slave Server version: 10.1.14-MariaDB MariaDB Server
all works fine -the only issue is when someone changed a table for example if we need to ALTER TABLE in the master - what is the best way?
as for now, the slave getting stuck and says that he "Unknown column" so we need to:
- stop slave
- alter table
- skip counter
- start slave
can you please recommend of a better way ? maybe to change it first at the slave ?
Answer Answered by IT IT Mig in this comment.
Proper way to sent alter to a master without messing up the replication is
- instead of ALTER DBNAME.TABLE
you use the
-USE DBNAME and then -ALTER TABLE TABLENAME
the use database helped me,