Built himself a master-slave synchronization, can synchronize the create, alter operation, such as can't insert synchronization operation

CodePudding user response:

Can list specific to what effect

CodePudding user response:

For the show on the slave status \ G what is the result?
Host the show master logs look up to the last log, then look at have corresponding log operations such as insert

CodePudding user response:

reference 1st floor kaijie_wu1209 response:

can list specific to achieve what effect

Data synchronization is normal, when the binlog pattern is the Row, can only be synchronized DDL, DML operations not synchronization

CodePudding user response:

refer to the second floor ZJCXC response:

for the show on the slave status \ G what is the result?
Host the show master logs look up to the last log, then look at have corresponding log operations such as insert

Hello:
Binlog is Row mode,
Phenomenon is only synchronous DDL operations to synchronous DML operations,
Master the binlog is Write_rows events, but to see the show in the slave binlog events in '000013' mysql - bin. There is no Write_rows;
And I put the binlog mode to the statement and mixed are synchronous, do you know why

CodePudding user response:

Show under the slave on the slave status, see if there are any abnormalities, is there any configuration screen, in addition to check the relay this information under the log, see if there is write - rows of events
Slave in the binlog no strange, because you may have no open log_slave_updates

CodePudding user response:

reference 5 floor ZJCXC reply:

slave see show on slave status, see if there are any abnormalities, is there any configuration screen, in addition to check the relay this information under the log, see if there is write - rows of events
Slave in the binlog no strange, because you may have no open log_slave_updates

Sorry now just back, outside ON a business trip, I look at the relay_log content, is write_rows events, and slave log_slave_updates state is ON, seems to be a slave does not perform insert operations in the relay