The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB Replication

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:

  1. stop slave
  2. alter table
  3. skip counter
  4. start slave

can you please recommend of a better way ? maybe to change it first at the slave ?

thanks

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,

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.