Database Management MySQL Subjective
Oct 01, 2025

Explain MySQL's binary logging and its formats.

Detailed Explanation

Binary logs record all changes for replication and point-in-time recovery.

Formats:
STATEMENT: Logs SQL statements
ROW: Logs actual row changes
MIXED: Automatically chooses format

Configuration:
log-bin=mysql-bin
binlog-format=ROW
expire_logs_days=7

Example:
SHOW BINARY LOGS;
mysqlbinlog mysql-bin.000001

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback