Reduce the size of MySQL NDB binlog

Question

I am running NDB Cluster and I see that on mysql api nodes, there is a very big binary log table.

+---------------------------------------+--------+-------+-------+------------+---------+
| CONCAT(table_schema, '.', table_name) | rows   | DATA  | idx   | total_size | idxfrac |
+---------------------------------------+--------+-------+-------+------------+---------+
| mysql.ndb_binlog_index                | 83.10M | 3.78G | 2.13G | 5.91G      |    0.56 |

Is there any recommended way to reduce the size of that without breaking anything? I understand that this will limit the time frame for point-in-time recovery, but the data has is growing out of hand and I need to do a bit of clean up.

Answer 1

It looks like this is possible. I don't see anything here: http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-replication-pitr.html that says you can't based on the last epoch.

Some additional information might be gained by reading this article:

http://www.mysqlab.net/knowledge/kb/detail/topic/backup/id/8309

The mysql.ndb_binlog_index is a MyISAM table. If you are cleaning it, make sure you don't delete entries of binary logs that you still need.