Data sorting in MySQL Cluster?

[debsweb]

We are using the MySQL Cluster engine to replicate data across two servers. Prior to using the Cluster engine, data was sorted properly and now there appears to be not sorting whatsoever. The data is sorted differently (randomly) on each server I look at. This is particularly irritating for one of our front-end applications which displayed the default table based on the first table noted in the table name table -- the default table was always given a name that would appear first alphabetically in the list. Now that we're using the Cluster engine, we've had to modify the code on our front-end application because there is no rhyme or reason to the sorted order of anything in any table. Setting an 'index' on the field has no effect.

Just wondering if there is something in the setup/options that would enable proper sorting in the cluster tables.

Thanks!
Debbie