Binary Log Format in MySQL

Posted by amritansu on Server Fault See other posts from Server Fault or by amritansu
Published on 2013-11-06T02:52:22Z Indexed on 2013/11/06 3:57 UTC
Read the original article Hit count: 542

Filed under:
|

Reference manual for MySQL 5.6 states that " Some changes, however, still use the statement-based format. Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. "

Does this statement means that even if we have ROW format for binary logs all DDLs will be logged in binary log as statement based? How does this affect replication?

Kindly help me to understand this.

© Server Fault or respective owner

Related posts about mysql

Related posts about binary-log