can not use indexes with mySQL Cluster?

[missy hogan]

Good evening. I am hoping someone can help me. When I try to create indexes with the ndb storage engine, the index is only created on the originating server. Basically I have 1 server with the correct index and 3 servers with no index. This is having a large impact on my performance. Any suggestions or assistance would be greatly appreciated.

My setup:
4 servers each running the mySQL API and ndb storage engine - 1 of those servers is also running the management server. They all sit behind a load balancer.

Example queries:
CREATE TABLE Example(
`expID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`expNoIndex` TINYINT UNSIGNED NOT NULL DEFAULT 3,
INDEX `idx_expNoIndex`(`expNoIndex`)
) TYPE = NDB;


Run this on the node 1 (storage and api node 1 reside on the first server)


Example Queuries:

SELECT COUNT(*) FROM Example WHERE expNoIndex = 3

If you run this on node 1 it will return a correct count/or result set, if run on any
of the other 3 api nodes you receive a null returned.


SELECT COUNT(*) FROM Example IGNORE INDEX(idx_expNoIndex) WHERE expNoIndex = 3


This query will (obviously slower) return on all 4 nodes properly.

Thank you,
Missy Hogan