can a MySQL subordinate instance have different row values ββfor the same identifier when binlog_format is set to STATEMENT, and we insert something like:
insert into foo values(CURRENT_TIMESTAMP)
As I understand it, the subordinate reads the SQL statement and executes it in this way, if replication is lagging behind, it can lead to differences for the same row. Right or wrong?
How can I avoid this situation?
Thank.
source
share