Binlog_format = STATEMENT and CURRENT_TIMESTAMP with MySQL Replication

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.

+3
source share
1 answer

. TIMESTAMP , CURRENT_TIMESTAMP , . NOW() .

, , SYSDATE(), TIMESTAMP , , , .

+5

Source: https://habr.com/ru/post/1746087/


All Articles