Bug #29428 Can't set binlog_format if NDB is enabled, but format is set to mixed...
Submitted: 28 Jun 2007 19:31 Modified: 29 Aug 2007 15:35
Reporter: Brian Aker Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: MC Brown CPU Architecture:Any

[28 Jun 2007 19:31] Brian Aker
Description:
Compile with NDB. Now NDB should only work with ROW based format, but the default format is set to MIXED and can not be changed.

We  now have an engine flag to handle format, I believe this restriction is not only wrong, but just a historical element of early 5.1.

http://dev.mysql.com/doc/refman/5.1/en/replication-formats-setting.html

How to repeat:
Compile with NDB, then trying setting:
mysql> SET SESSION binlog_format = 'STATEMENT';

Dare you!

Suggested fix:
Remove hardcoded approach to replication when NDB is installed.
[29 Jun 2007 9:09] Sveta Smirnova
Thank you for the report.

But this limitation does not exists in current sources. So I changed category of the report to "Documentation"
[29 Jun 2007 14:30] Brian Aker
Documentation is the right way to go.
[29 Aug 2007 15:35] MC Brown
This situation has been documented as part of the documentation of engine-driven binary log setting.