I have a replicated MySQL database that until recently was supported by a DBA. Unfortunately, he has now left so we're playing catch up.
From what I can tell the replication that is set up is:
- binary_log based (i.e. not GTID)
- row based
- the table being altered is InnoDB
I'm basing this on a few things
- The output from
SHOW SLAVE STATUS
references the binary log - The
mysql.gtid_executed
table on the master and slave are both empty - The output from
SHOW GLOBAL VARIABLES LIKE 'binlog_format';
isROW
The master server is using MySQL version 5.7.9. The slave is using MySQL version 5.7.17
If I change a column name in the master database using the command
ALTER TABLE table_name CHANGE COLUMN old_column_name new_column_name DATETIME NOT NULL
will the change be replicated to the slave?
Or do I need to change the column name in the slave as well?