I have some MySQL replication going on, and want to change the schema of the slave by adding a column. Will this work?
Mysql – Master and Slave MySQL databases with different schemas
MySQLmysql-replication
MySQLmysql-replication
I have some MySQL replication going on, and want to change the schema of the slave by adding a column. Will this work?
Best Answer
Yes. Keep in mind, the queries will replicate and execute identically on the slave as with the master. If the column is on the end of the table, it could simply use the default value. If it is in the middle, you could introduce data type conflicts or potentially even replication failure if the insert failed.