EC
3200
MariaDBERRORCommonReplicationHIGH confidence

Replica requires row-based binary log format

Production Risk

Critical — replication stops.

Why it happens
  1. 1Primary is using STATEMENT or MIXED format but the replica requires ROW format.
  2. 2Partial update or JSON diff replication requires ROW-based logging.
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs on replica when a statement-based event cannot be safely applied.

expected output

ERROR 3200 (HY000): Slave requires row-based binary logging.

Fix

Switch primary to ROW format

Switch primary to ROW format
SET GLOBAL binlog_format = 'ROW';

Why this works

ROW format provides the per-row change data needed for safe replication.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 3200 ER_SLAVE_REQUIRE_ROW_FORMAT

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

← All MariaDB errors