- Default Drupal installations use MyISAM storage engine
- Most plugins assume MyISAM storage engine for tables
- Many have switched to InnoDB
If is straightforwards to convert MyISAM to InnoDB, such as with the following:
ALTER TABLE node ENGINE=InnoDB;
Not so with NDB. For the table
node, let's take the following approach:
mysqldump -u... -p... dbname --no-create-info node > node_data.sql
Then, load the table into the NDB Cluster
mysql -u... -p... -Ddbname -A < node_data.sql
and you let all the management nodes and SQL nodes determine where to store/shard the data.
If and only if you have the patience to
- upgrade Drupal
- avoid using FULLTEXT indexes (currently not supported by NDB)
- apply plugins
- drop FULLTEXT indexes
- convert any MyISAM tables to NDB
- migrate/reload data
then it is worth a shot.
Please post NDB Cluster questions in the DBA StackExchange.
DISCLAIMER : Not Drupal Expert, Not CMCDBA (not Cluster Certified), just CMDBA