Trying to setup MySQL clustering

Portal Home > Knowledgebase > Articles Database > Trying to setup MySQL clustering

Posted by anlene, 05-12-2015, 11:31 PM
Hi all, I am trying to setup clustering using 3 servers. 1 for the Management Node and 2 Data Nodes. Currently I have succeeded by having 2 data node connecting to the Management node. Right after I'm totally lost on how to fire up MySQL and create the necessary tables using the NDBCluster engine. In one of my data node, I try logging in to mysql and when I do a "show engines", I get NDBCLUSTER Not Supported. I tried to reinstall mysql by doing yum install mysql-server but failed due to some conflicts. Would really appreciate if someone here have any idea on how to get ndbcluster engine to work.
Posted by jaijop, 05-13-2015, 12:36 AM
Hello, Please try to install MySQL-Cluster-gpl rpms which supplies the core files needed to run a MySQL Server with NDBCLUSTER storage engine support. Please refer the below ink to know more information. https://dev.mysql.com/doc/refman/5.1...linux-rpm.html Thanks, Jaijo
Posted by anlene, 05-13-2015, 01:38 AM
Hi jaijo, thanks for the reply. Currently I have the following packages installed: MySQL-Cluster-embedded-gpl-7.4.6-1.el6.x86_64 MySQL-Cluster-devel-gpl-7.4.6-1.el6.x86_64 MySQL-Cluster-client-gpl-7.4.6-1.el6.x86_64 MySQL-Cluster-server-gpl-7.4.6-1.el6.x86_64 MySQL-Cluster-test-gpl-7.4.6-1.el6.x86_64 As the above, I am able to start the data node cluster and connect to the management node but mysql still doesn't support nbscluster engine. My system is using Centos so currently I am using yum to do installation. I'm not sure if yum have any limitations on the packages?
Posted by jaijop, 05-13-2015, 01:50 AM
Hi, Please check that ndbcluster is enabled on my.cnf ndbcluster # run NDB storage engine ie /etc/my.cnf: [mysqld] # Options for mysqld process: ndbcluster # run NDB storage engine Thanks, Jaijo
Posted by anlene, 05-13-2015, 02:14 AM
Hi JJ I only have the following sets of my.cnf in my system. /root/MySQL_Cluster/52/my.cnf (Auto Generated by Management Node) /root/MySQL_Cluster/53/my.cnf (Auto Generated by Management Node) What is confusing to me now is, after I have installed the cluster packages, do I still have to install the MySQL database or it is already included in the cluster package? But if I try to install MySQL, it prompts me with conflict error as mentioned in my first post.
Posted by jaijop, 05-13-2015, 02:23 AM
Hi, No need to install MYSQL database separately as it is already included in the cluster packages. Please try again with a fresh installation and let me know if you have trouble again. If so I can able to do it for you. I'm having hands own experiance in configuring MySQL clustering. Please go through my WHT profile http://www.webhostingtalk.com/showthread.php?t=1478162 Please add me in skype or send me the details to my mail id ( both skype & mail id is there in my profile). Thanks, Jaijo