1576
MariaDBERRORNotableReplicationHIGH confidence

Row-based replication not available

Production Risk

Medium — replication format cannot be changed as intended.

What this means

Row-based binary logging was requested but is not available in this build or configuration.

Why it happens
  1. 1The MySQL binary was compiled without row-based replication support.
  2. 2Attempting to set binlog_format=ROW on a build that does not support it.
How to reproduce
trigger — this will error
trigger — this will error
SET GLOBAL binlog_format = 'ROW';

expected output

ERROR 1576 (HY000): Row-based binary logging is not available

Fix

Use a MySQL build that supports row-based replication

Use a MySQL build that supports row-based replication
-- Upgrade to a standard MySQL distribution that includes RBR support.

Why this works

Row-based replication is included in all standard MySQL 5.1+ distributions.

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 1576 ER_RBR_NOT_AVAILABLE

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors