Posted by showmanlkz on August 4, 2011 at 4:24am
Hi guys, my organization is running a MySQL Cluster 7.x. I have been quite comfortable to port some of our MySIAM type tables to MySQL Cluster's NDB type.
I found that drupal uses innoDB, so I am wondering if it's possible to port it to NDB type?
FYI, MYSQL Cluster NDB doesn't support few things in innoDB include foreign key constraints.
http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html
Any opinion will be welcomed.
Derrick
Comments
Drupal's database to MySQL Cluster possible?
Hi, I have a site using 105 contrib modules as follows:
admin
advanced_help
agreement
amfphp
auto_nodetitle
autologout
cas
comment_service
content
content_copy
ctools
cvs_deploy
data
data_node
data_search
data_taxonomy
data_ui
date
date_api
date_popup
date_repeat
date_timezone
devel
dialog
dirtyforms
ds
ds_ui
fckeditor
features
feeds
feeds_ui
fieldgroup
file_service
filefield
filefield_meta
filter_default
flag
front_page
getid3
hierarchical_select
hs_menu
hs_taxonomy
htmlpurifier
i18n
i18nblocks
i18ncck
i18ncontent
i18nmenu
i18nprofile
i18nstrings
i18nsync
i18ntaxonomy
imageapi
imageapi_gd
imagecache
imagecache_ui
imagefield
job_scheduler
jquery_plugin
jquery_ui
jquery_update
lang_dropdown
link
memcache_admin
menu_per_role
menu_service
mimedetect
nd
nd_cck
node_service
nodereference
nodereferrer
number
og
og_mandatory_group
og_user_roles
og_views
onbeforeunload
optionwidgets
password_strength
quicktabs
schema
search_service
services
services_keyauth
session_aggregator
session_limit
signup
signup_status
system_service
taxonomy_service
text
token
transliteration
unique_field
user_service
userreference
views
views_bulk_operations
views_customfield
views_export
views_service
views_ui
xmlrpc_server
Can I implement the mysql cluster on my site? as I came to know there are many limitations are in NDBCluster like
Problem in Like function on mysql query.
Problem with Joining on bigger query
how we can overcome on these issues.
And also like to know if there any suitable module to test all these active modules are suitable or not for ndb cluster?
Looking for your reply!
Thanks
For me, it's not possible
NDB is completly different product. It's not like choosing between myisam and innodb. If you can't scale with a varnish, a memcache, a CDN, a Solr with more than one server, you have a lot of users and you can start to build specific application. Without NDB, NDB is for laboraotry, not for real world.
Implementing Drupal 6.17 in Mysql Cluster 7.2!!
Thanks for your reply!
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, can you please help me on that.
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.
I 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.
Looking for your reply!
Have a look at Acquia
Have a look at Acquia architecture. NDB can't handle joining efficiently, it's a CAP theorem effect. Most drupal's modules are made for mysql. Your issues are physical, it's a dead end.
Why do you need LIKE queries? Solr is far better for handling full text esarch and multi byte characters.