Sep 13, 2018

How to check / set MySQL Replication Format

There are 3 replication formats:
  1. statement-based replication (often abbreviated as SBR)
  2. row-based replication (often abbreviated as RBR)
  3. When the mixed format is in effect, statement-based logging is used by default, but automatically switches to row-based logging in particular cases as described later. Replication using the mixed format is often referred to as mixed-based replication or mixed-format replication.
Show / set binlog_format variable to dynamically change the format.

show global variables like 'binlog_format'