Drupal & MySQL 5.x Cluster
I setup a MySQL 5.0 Cluster on a spare server with multiple Xen VMs and discovered that Drupal 6 (and most likely D7 as wel) as it exists today cannot function properly under the MySQL NDBCLUSTER engine. It seems that under the NDBCLUSTER engine (also known as NDB), D6 has a table called menu_router that fails to be converted.
I posted a bug report about it under the D6 platform as it is rather detailed, but I have an idea this will affect D7 as well.
http://drupal.org/node/391130
Groups:
Login to post comments
NDB not well suited to Drupal
http://buytaert.net/database-replication-lag
Excerpt:
MySQL provides a synchronous replication model through the NDB cluster storage engine. Stability issues aside, MySQL's cluster technology works best when you avoid JOINs and sub-queries. Because Drupal is highly relational, we might have to rewrite large parts of our code base to get the most out of it.
Cheers
Slides
I can't find it now, but someone in Europe tried getting the entire d.o into NDB. Kris Buytaert or Krimson or something like that. They published slides about it.
It was not a good fit due to various reasons detailed in that presentation.
Drupal performance tuning, development, customization and consulting: 2bits.com, Inc..
Personal blog: Baheyeldin.com.