MySQL Forums
Forum List  »  Partitioning

Re: Mysql cluster 7.1.5 can't use table partition!
Posted by: Rick James
Date: August 26, 2010 10:27PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql cluster 7.1.5 can't use table partition!
1583
August 26, 2010 10:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.