MySQL Forums
Forum List  »  NDB clusters

Re: binlog not recording DML Statement
Posted by: Nooruddin Dalvi
Date: May 28, 2020 06:59AM

Thanks Jon,

It is working now after enabling ndb_log_bin.

ndb_log_bin | ON

mysql> insert into friends value ('SAMSON');
Query OK, 1 row affected (0.01 sec)

mysql> commit
-> ;
Query OK, 0 rows affected (0.00 sec)

mysql> show binlog events in 'ndbcluster-bin.000010';
+-----------------------+-----+----------------+-----------+-------------+-------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-----------------------+-----+----------------+-----------+-------------+-------------------------------------------+
| ndbcluster-bin.000010 | 4 | Format_desc | 101 | 125 | Server ver: 8.0.20-cluster, Binlog ver: 4 |
| ndbcluster-bin.000010 | 125 | Previous_gtids | 101 | 156 | |
| ndbcluster-bin.000010 | 156 | Anonymous_Gtid | 101 | 235 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
| ndbcluster-bin.000010 | 235 | Query | 101 | 306 | BEGIN |
| ndbcluster-bin.000010 | 306 | Table_map | 101 | 363 | table_id: 107 (test.friends) |
| ndbcluster-bin.000010 | 363 | Table_map | 101 | 435 | table_id: 92 (mysql.ndb_apply_status) |
| ndbcluster-bin.000010 | 435 | Write_rows | 101 | 500 | table_id: 92 |
| ndbcluster-bin.000010 | 500 | Write_rows | 101 | 543 | table_id: 107 flags: STMT_END_F |
| ndbcluster-bin.000010 | 543 | Query | 101 | 615 | COMMIT |
+-----------------------+-----+----------------+-----------+-------------+-------------------------------------------+
9 rows in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: binlog not recording DML Statement
20
May 28, 2020 06:59AM


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.