Re: Mysql cluster 7.1.5 can't use table partition!

[Rick James]

True. Please explain why you want both Cluster and Partition. Maybe we can suggest an alternative design.

PARTITION applies to the 'normal' table types of MyISAM and InnoDB.

Some history: MySQL started out as just ISAM (later MyISAM). As time went on, they added on other "Engines" (and rewrote the kernel to better handle such). The first main one was InnoDB, from Innobase. Later came NDB Cluster, which was a high-speed, high availablity, telco engine. InnoDB could easily enough fit into the "engine" architecture, but Cluster was really a different animal. Eventually Federated and Partition were added on as (sort of) an extra layer above the standard Engines.

Other notables:
BDB -- came and died due to licensing problems
InfoBright -- 3rd party "column" "data warehouse" engine
Xtradb -- promising replacement for InnoDB
MariaDB -- next generation MyISAM, with many of the good features of InnoDB (from Monty Program)
Spider -- (3rd party) merging Federated and Partitioning into a viable combo.

Apologies to the dozen other addons/engines/plugins/etc.