Re: Change NDB transaction behavior to mimic InnoDB

[Mikael Ronström]

Hi,

Matthew Boehm Wrote:
-------------------------------------------------------
> Hello,
> We have a Master/Slave cluster setup. Looking at
> binary logs on the master, I can see that many
> independent transactions get "bundled up" in to 1
> larger transaction.
>
> I can see "BEGIN; <several hundred DMLs>; COMMIT;"
> in the binlog of the master. We have
> autocommit=ON.
>
> With InnoDB, I would see "BEGIN; <1 DML>; COMMIT;"
> for each transaction.
>

Sounds like you are using statement-based replication
for InnoDB.

NDB uses row-based replication.

Rgrds Mikael Ronström

> How can I turn off this behavior in NDB so that
> each transaction is actually it's own
> transaction?
>
> I believe this is causing our consistency checks
> to report false-positives because things are being
> done out of order.
>
> Thanks,
> Matthew