# All three ndb-plugins should be ENABLED SELECT RPAD(PLUGIN_NAME, 33, ' ') 'PLUGIN_NAME ', LOAD_OPTION, PLUGIN_STATUS, PLUGIN_TYPE FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'ndb%' ORDER BY PLUGIN_NAME; PLUGIN_NAME LOAD_OPTION PLUGIN_STATUS PLUGIN_TYPE ndbcluster ON ACTIVE STORAGE ENGINE ndbinfo ON ACTIVE STORAGE ENGINE ndb_transid_mysql_connection_map ON ACTIVE INFORMATION SCHEMA # Both ndb-engines should be enabled (SUPPORT YES) SELECT RPAD(ENGINE, 10, ' ') 'ENGINE ', SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 'ndb%' ORDER BY ENGINE; ENGINE SUPPORT ndbcluster YES ndbinfo YES # ndb schemas SELECT DISTINCT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE 'ndb%' ORDER BY TABLE_SCHEMA; TABLE_SCHEMA ndbinfo # ndb tables SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'ndb%' ORDER BY TABLE_SCHEMA, TABLE_NAME; TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE information_schema ndb_transid_mysql_connection_map SYSTEM VIEW NULL mysql ndb_apply_status BASE TABLE ndbcluster mysql ndb_binlog_index BASE TABLE InnoDB performance_schema ndb_sync_excluded_objects BASE TABLE PERFORMANCE_SCHEMA performance_schema ndb_sync_pending_objects BASE TABLE PERFORMANCE_SCHEMA # There should be many ndb variables SELECT COUNT(*) >= 69 FROM performance_schema.session_variables WHERE variable_name LIKE 'ndb%'; COUNT(*) >= 69 1 MYSQLD --help --verbose # ALL OFF output_line ndb-transid-mysql-connection-map OFF ndbcluster OFF ndbinfo OFF MYSQLD --ndbcluster=0 --ndbinfo --help --verbose # ALL OFF output_line ndb-transid-mysql-connection-map OFF ndbcluster OFF ndbinfo OFF MYSQLD --ndbcluster --help --verbose # ALL ON output_line ndb-transid-mysql-connection-map ON ndbcluster ON ndbinfo ON MYSQLD --ndbcluster=1 --ndbinfo=0 --help --verbose # ndbinfo OFF output_line ndb-transid-mysql-connection-map ON ndbcluster ON ndbinfo OFF MYSQLD --ndbcluster=1 --ndb-transid-mysql-connection-map=0 --help --verbose # ndb-transid-mysql-connection-map OFF output_line ndb-transid-mysql-connection-map OFF ndbcluster ON ndbinfo ON