drupal and ndb cluster engines

Question

we have an application which was built with drupal connecting to a mysql db. upon go-live we found that the production db is a clustered one and requires us to change our db tables to NDB cluster engines.

Is drupal capable of working with clustered db's and how do we do this?

Answer 1

OBSERVATIONS

• Default Drupal installations use MyISAM storage engine
• Most plugins assume MyISAM storage engine for tables
• Many have switched to InnoDB
  • What tables should or could be migrated to InnoDB, and which should remain MyISAM?
  • How do I convert a database from MyISAM to InnoDB?
  • FULLTEXT indexes not supported in InnoDB in MySQL 5.5
  • FULLTEXT indexes are supported in InnoDB in MySQL 5.6 (when it goes GA)

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