mysql replication: table structure change doesn’t take effected, only records are updated, why?
use mysql v8.4.3, for both main database and slave, binlog_format set to “row”,
I found any changes to the main database tables, such as add columns, create new table, doesn’t reflected in the slave side, only the records update.
why? how to have all the changes include records and table structure changes reflect in slave side.
thanks advanced.
i want to replicate old tables present on master machine also on to my slave machines how to do this?
my current replication is going on correctly in realtime now, i want to replicate old tables present on master machine also on to my slave machines how to do this?