TungNT (Blue)

You've loaded an old revision of the document! If you save it, you will create a new version with this data.

====== Debezium MySQL ======

===== Binlog (binary log) =====

**Kiểm tra xem MySQL đã bật chế độ ghi log nhị phân hay chưa bằng lệnh:**

<code sql>
SHOW VARIABLES LIKE 'log_bin';
</code>

Nếu kết quả là 'ON', binlog đang được bật.

**Liệt kê các tệp binlog:**

<code sql>
SHOW BINARY LOGS;
</code>

**Xem nội dung binlog:**

<code sql>
tungnt@MacBook-Pro-cua-Nguyen-2 mysql % mysqlbinlog /opt/homebrew/var/mysql/binlog.000217
# The proper term is pseudo_replica_mode, but we use this compatibility alias
# to make the statement usable on server versions 8.0.24 and older.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#241021 13:19:55 server id 1  end_log_pos 127 CRC32 0x609227a3 	Start: binlog v 4, server v 8.4.2 created 241021 13:19:55 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
i/IVZw8BAAAAewAAAH8AAAABAAQAOC40LjIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAACL8hVnEwANAAgAAAAABAAEAAAAYwAEGggAAAAAAAACAAAACgoKKioAEjQA
CigAAAGjJ5Jg
'/*!*/;
# at 127
#241021 13:19:55 server id 1  end_log_pos 158 CRC32 0xcf101e2a 	Previous-GTIDs
# [empty]
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
</code>

Please fill all the letters into the box to prove you're human. U Z V᠎ S U Please keep this field empty:

Edit summary