innodb_autoinc_lock_mode = 2 with replication and binlog_format='MIXED'

[Eyal Sorek]

Hi,

Is it safe to use innodb_autoinc_lock_mode = 2 with binlog_format='MIXED' and replication ?

When inserting a record with auto inc column, would mysql will switch to row based replication, in this case, and the values generated for the auto inc columns will be deterministic on the master and the salve.

In the doc in 5.2.4.3. Mixed Binary Logging Format:

When running in MIXED mode, automatic switching from statement-based to row-based replication takes place under the following
conditions:
...
• When 2 or more tables with AUTO_INCREMENT columns are updated
...

But it doesn't mention conclusive the scenario I asked above in consistent way.

Thanks,
Eyal.