1563
MariaDBERRORNotableReplicationHIGH confidence
NDB cluster cannot switch binlog format
Production Risk
Low — the change is refused; cluster operation continues normally.
What this means
The NDB storage engine does not support switching the binary log format dynamically.
Why it happens
- 1Attempting to change binlog_format on a server using NDB Cluster tables.
How to reproduce
trigger — this will error
trigger — this will error
SET GLOBAL binlog_format = 'STATEMENT'; -- on NDB cluster node
expected output
ERROR 1563 (HY000): The NDB cluster engine does not support changing the binlog format on the fly yet
Fix
Set binlog_format at server startup
Set binlog_format at server startup
-- In my.cnf: binlog_format = ROW
Why this works
NDB Cluster requires binlog_format to be configured at startup, not changed dynamically.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1563 ER_NDB_CANT_SWITCH_BINLOG_FORMAT
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev