Posted by Swampcritter on March 12, 2009 at 1:58pm
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
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.
Drupal performance tuning, development, customization and consulting: 2bits.com, Inc..
Personal blog: Baheyeldin.com.
The presentation is located
The presentation is located at http://www.slideshare.net/KrisBuytaert/drupal-mysql-cluster. According to the presentation, the limitation is the memory you have available to your DB nodes, since the best performance requires that all data be stored in memory. Apparently some D.O. tables simply did not fit in memory. The slide at the end says that NDB is great for smaller datasets, but look to MySQL Proxy for larger datasets.
We are successfully running on ndbcluster
We are running our intranet portal with success on a MySQL cluster, ndbcluster tables. I filed/updated some issues in hopes that we can eventually bring ndbcluster support to core, but in the meantime, you can find the steps for installation here: http://www.nowarninglabel.com/home/drupal-mysql-cluster-ndbcluster-high-...
Drupal evangelist.
www.CoderintheRye.com
Drupal's database to MySQL Cluster possible?
I currently working on a project to implement a existing Drupal 6.17 site in Mysql Cluster. Our basic requirement was to enhance the scalability to support huge number of users in the system.
he site is using 105 contrib modules including:
cas
comment_service
content
data_search
ds
feeds
getid3
i18n
job_scheduler
memcache_admin
og
services
session_aggregator
session_limit
signup
token
views
views_bulk_operations
xmlrpc_server
I have already setup a mysql cluster 7.2.4 with the recommended minimum config and done the configuration change to fit the structure and the data has been ported to the structure.
Now I am stuck with two major issues - (1) Complex joins are running very slow (2) LIKE %% is not working with the multi byte character set in the mysql cluster and looking for solutions in DB Layer.
By reading on different blogs and forums I came to know that mysql cluster can be implement in DRUPAL, But here I am stuck to implement in real world.
Actually I need a clear picture where and which areas our Drupal does not allow to implement the NDB cluster, Or How can I overcome with these issues!
Can you please help me on that.