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