MySQL Forums
Forum List  »  NDB clusters

NDB Cluster binlog order
Posted by: Francisco Javier Montaño Flores
Date: November 11, 2019 06:44AM

I am facing an issue with how NDB writes to the binlog: It seems that some statements are being written in an order that differs from the one which they have been executed.
I have that NDB acting as a master in a replication stack and this behaviour makes the slave node to fail.

Reviewing my configuration, everything looks fine, but there must be something wrong I am not seeing. Can you help me?

master (cluster) configuration:

-binlog_order_commits=ON
-innodb_api_enable_binlog=OFF
-innodb_flush_log_at_trx_commit=1
-log_bin=ON
-log_slave_updates=OFF
-slave_parallel_type=DATABASE
-slave_parallel_workers=0
-slave_preserve_commit_order=OFF
-sync_binlog=1
-ndb_log_binlog_index
-ndb_log_updated_only=ON
-ndb_log_update_as_write=OFF


slave (innodb) configuration:

-binlog_order_commits=ON
-innodb_api_enable_binlog=OFF
-innodb_flush_log_at_trx_commit=1
-log-bin
-log_slave_updates=ON
-slave_parallel_type=DATABASE
-slave_parallel_workers=0
-slave_preserve_commit_order=OFF
-sync_binlog=1

Options: ReplyQuote


Subject
Views
Written By
Posted
NDB Cluster binlog order
273
November 11, 2019 06:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.