importing databases and changing engines
Hi,
i'm new to mysql clustering, i have installed it using the configurator at severalnines.com, using mysql 5.6.11-ndb-7.3.2-cluster-gpl
i have a severalnines clustercontrol server, 2 management servers, 4 data servers (2 node groups), and 8 query nodes. all the mysql servers are on the same subnet.
everything appears to be working fine, i've got the user accounts available on each query node using the ndb_dist_priv.sql routine, i have two servers running haproxy in front of the query nodes for load-balancing.
i am intending to host websites on a 16 server apache farm. again, load-balanced by haproxy. with all the database work offloaded to the mysql cluster.
i've tried importing an existing wordpress database, having edited the dumpfile, changing all instances of MyISAM to NDBCLUSTER
however some of the keys are not allowed as indexes using the ndb engine. TEXT and FULLTEXT being the ones i've encountered so far.
i've deleted the offending keys from the file and imported the database successfully, just so i could test the load balancing worked. i am aware this would break some functionality, so how should i handle them properly?
i've seen suggestions of changing them to VARCHAR, but i'm not really a database administrator, i have no idea what problems that could cause, or if that would provide enough space for all of a FULLTEXT entry.
can i have most of the tables using NDBCLUSTER, and leave the offending tables as MyISAM? if so, how do i replicate those tables across all 8 query servers?
there will also be some magento databases (innoDB), which will have issues with foreign key constraints when trying to change to ndbcluster.
i've seen suggested this:
You can try running this at the top of your database dump:
SET FOREIGN_KEY_CHECKS = 0;
is this ok? will triggers work ok?
thanks for any help and advice you can give.
lee.