Bug #67032 new binary log does not get populated to ndb_binlog_index table for DDL

• Submitted: 1 Oct 2012 11:02
• Modified: 26 Dec 2012 11:32
• Reporter: krishna chandran g
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S4 (Feature request)
• Version: 7.2.6
• OS: Linux (RHEL 5.6)
• CPU Architecture: Any

[1 Oct 2012 11:02] krishna chandran g

Description:
binlog file details are not getting updated on ndb_binlog_index if the qery is just DDL.

How to repeat:
flush the binary logs.
Execute DDL statements(say crate table...).
Check the file name and position entry on ndb_binlog_index table.
The file details won’t be available.
Unless we execute any DML statement the curresponding log details wont reflect on ndb_binlog_index table.
This issue will create problem while restoring the data to a new server.

[1 Oct 2012 11:10] krishna chandran g

Just added the correct version

[2 Oct 2012 6:59] krishna chandran g

Example

Attachment: log.txt (text/plain), 7.05 KiB.

[8 Oct 2012 4:59] krishna chandran g

I got the schema details from different table (ndb_schema.)

[26 Dec 2012 11:32] MySQL Verification Team

Yup, you can get the schema change details from mysql.ndb_schema table, more details - http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-replication-schema.html

mysql> select * from mysql.ndb_schema;
+--------+--------+----------------------------------+-------------------------------------------------+---------+-------+-----------+-----------+------+
| db     | name   | slock                            | query                                           | node_id | epoch | id        | version   | type |
+--------+--------+----------------------------------+-------------------------------------------------+---------+-------+-----------+-----------+------+
| defect |        |                                  | create database defect                          |       4 |     0 | 521595368 | 294702567 |    5 |
| defect | tbrep3 |                                  | alter table tbrep3 add column(name varchar(10)) |       4 |     0 |        11 |         1 |    7 |
+--------+--------+----------------------------------+-------------------------------------------------+---------+-------+-----------+-----------+------+