MySQL Cluster 7.3 GA – Includes MySQL Cluster Auto-Installer

MySQL Cluster 7.3 has just been declared Generally Available (and with it the new MySQL Cluster Auto-Installer) – download it from here.

Deploying a well configured cluster has just got a lot easier! Oracle have released a new auto-installer/configurator for MySQL Cluster that makes the processes extremely simple while making sure that the cluster is well configured for your application. A single command launches the web-based wizard which then steps you through configuring the cluster; to keep things even simpler, it will automatically detect the resources on your target machines and use these results together with the type of workload you specify in order to determine values for the key configuration parameters.

For a broader view of what is being released – check out this MySQL Cluster 7.3 GA article.

Tutorial Video

Before going through the detailed steps, here’s a demonstration of the auto-installer in action (note that this is actually an earlier version but the idea is the same)…

Downloading and running the wizard

The software can be downloaded as part of the MySQL Cluster package from the MySQL Cluster Download page. To run on Windows, just double click setup.bat – note that if you installed from the MSI and didn’t change the install directory then this will be located somewhere like C:Program Files (x86)MySQLMySQL Cluster 7.3. On Linux, just run ndb_setup from the bin folder.

If you launch the installer from a desktop environment then the first page of the wizard will automatically be opened in your web browser, if not then just browse to the URL that is displayed on the command line.

Creating your cluster

Figure 1 Specify hosts and application type

Figure 1 Specify hosts and application type

After the initial splash-screen you’re presented with the page shown in Figure 1 where you specify the list of servers that will form part of the cluster.
You also get to specify what “type” of cluster you want; if you’re experimenting for the first time then it’s probably safest to stick with “Simple testing” but for a production system you’d want to specify the application type and query profile, i.e. write-intensive.

 

 

 

 

Figure 2 Auto-discovery of host resources

Figure 2 Auto-discovery of host resources

On the next page (Figure 2), you will see the wizard attempt to auto-detect the resources on your target machines. If this fails (e.g. if you don’t have an accessible SSH server on the target hosts) then you can enter the data manually. You can also overwrite the resource-values – for example, if you don’t want the cluster to use up a big share of the memory on the target systems then just overwrite the amount of memory.

It’s also on this page that you can specify where the MySQL Cluster software is stored on each of the hosts (if the defaults aren’t correct) – this should be the path to where you extracted the MySQL Cluster tar-ball file – as well as where the data (and configuration files) should be stored. You can just overwrite the values or select multiple rows and hit the “edit” button.

Figure 3 Review Cluster topology

Figure 3 Review Cluster topology

The following page (Figure 3) presents you with a default set of nodes (processes) and how they’ll be distributed across all of the target hosts – if you’re happy with the proposal then just advance to the next page.

Alternatively, you can add extra nodes, move nodes from one host to another (just drag and drop), delete nodes or change a node from one type to another.

 

 

 

Figure 4 Review configuration parameters

Figure 4 Review configuration parameters

On the next screen (Figure 4) you’re presented with some of the key configuration parameters that have been configured (behind the scenes, the installer sets many more) that you might want to override; if you’re happy then just progress to the next screen. If you do want to make any changes then make them here before continuing. Note that you can enable the advanced configuration option here in order to view/modify more parameters.

 

 

 

Figure 5 Deploy the Cluster

Figure 5 Deploy the Cluster

With the click of a button, the final screen (Figure 5) lets you deploy (copy the correct configuration settings to the hosts and create the directory structures) and start the Cluster.

If you prefer or need to start the processes manually, this page also shows you the commands that you’d need to run (as well as the configuration files if you need to create them manually).

A traffic light display shows the various Cluster nodes (processes) coming into service.

 

Figure 6: Confirm that all nodes are running

Figure 6: Confirm that all nodes are running

Finally, you can confirm that all of the processes (nodes) are up and running (note that any API slots that don’t have MySQL Servers using them won’t show as running – that’s as expected):

As always it would be great to hear some feedback especially if you’ve ideas on improving it or if you hit any problems.





137 comments

  1. Tarran Benson-West says:

    I can’t find the auto installer files in the release? They are in the 7.2.8 labs release, but there is no ndb_setup file in the bin directory for this release (Linux – Generic)?

    I tried copying the files out from the old install and although I managed to get the webserver to run and serve the clsuter install page, I got errors saying that certain modules weren’t available (panimiko?).

    Any ideas?

    • andrew says:

      Hi Tarran,

      are you sure that you downloaded 7.3.1 rather than 7.2 (you need to click to the Development Releases tab)? I’ve checked that it’s there in both the 32 and 64 bit tar balls.

      Andrew.

  2. Tarran Benson-West says:

    Hi Anderew,

    Schoolboy error i’m afraid.

    I forgot to specify the -z option when extracting the tarball. This would also probably explain the missing modules.

    Sorry for wasting your time.

    Tarran

  3. Igor says:

    I get this error when trying the autoinstaller on windows with mysql-cluster deployed on 2 ubuntu machines

    Command ‘/usr/local/mysql/bin/ndb_mgmd –initial –ndb-nodeid=49 –config-dir=/var/lib/mysql-cluster/49/ –config-file=/var/lib/mysql-cluster/49/config.ini’, running on 10.10.10.99 exited with 1:

    • andrew says:

      Igor,

      first thing to confirm is whether /usr/local/mysql/bin/ndb_mgmd is actually the correct path – does that file exist on your target machines? if not then go back a couple of screens and select the correct path.

      Also confirm that the configdir exists and is writeable.

      If neither of those is the problem then look for the Cluster log on the target machine for the ndb_mgmd and see if there are details of the error reported in there.

      Andrew.

  4. [...] new DMR 7.3.1 for MySQL Cluster. Our efforts to improve ease of use for Cluster continues, please learn more aboutm, and try out the autoinstaller. MySQL Cluster was there as a “NoSQL” database long before the term was coined, and was [...]

  5. Rafael Santiago says:

    hello certain Mr. andrew (forgive the lack of English, is tradudico by google.com).
    I would like to support me on a project, I’m not a consultant, but I like MySQL and Java
    Suppose I have 4 shops or stores, 4 stores devo install a MySQL server,
    Why? that sometimes the internet goes, then the BD deve ser Local, at the time
    the Internet comes, this report deve updates. Thus should pass on the 4 shops
    devo track inventory, if A sells a product in invetario Shop 1 and decreases
    in 4 shops, re deve reflect their inventory in stores or servers 4.
    Question. That take devo tool? whether or Cluster MySQL Replication or tool.
    Internet Connection in deve servers being on automatic. THANKS

  6. Sinan E. says:

    Hi,

    I have installed Mysql Cluster on 4 virtual linux servers (suse ent. 11 64bit) and all settings seem ok:

    localhost:~/Desktop # ndb_mgm -e show
    Connected to Management Server at: localhost:1186
    Cluster Configuration
    ———————
    [ndbd(NDB)] 2 node(s)
    id=3 @192.168.1.111 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master)
    id=4 @192.168.1.112 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0)

    [ndb_mgmd(MGM)] 1 node(s)
    id=1 @192.168.1.198 (mysql-5.5.30 ndb-7.2.12)

    [mysqld(API)] 1 node(s)
    id=11 @192.168.1.199 (mysql-5.5.30 ndb-7.2.12)

    localhost:~/Desktop #

    Problem is, when I create a table or make an insert/update/delete query on any node and check other node it does not seem there. Nothing is synced.

    Please help.

    • andrew says:

      Hi Sinan,

      what do you mean by checking on the other node? Looking at the output from ndb_mgm, you only have a single MySQL Server configured as part of the Cluster (running on 192.168.1.199. If you’ve run other mysqld processes then they’re not part of the Cluster and so they will not be sharing the same data.

      Regards, Andrew.

  7. Damian says:

    Hi Andrew,

    Is there any way to set MaxNoOfAttributes on the auto-installer? I can’t set it directly on the config.ini, since the auto-installer automatically overwrite my changes.

    Thanks!

    • andrew says:

      Hi Damian,

      on the final screen you’re shown the commands that are needed to manually start the Cluster – take a note of those. Rather than clicking on “Deploy and Start Cluster” click on “Deploy Cluster”. Now edit the config.ini file to set MaxNoOfAttributes and then start the Cluster using the commands you noted earlier.

      We’ll look into including MaxNoOfAttributes in the ‘expert’ mode.

      Thanks for the feedback!

      Andrew.

  8. Damian says:

    Hello Andrew,

    Is there any way to start the cluster without deploying it again on the autoinstaller? It’s hard to do the sequence one by one

  9. Damian says:

    Well, sorry to bother you again with this, I can’t edit my last comment but here is a list of commands with the number of the server at the beginning of each line

    10 /opt/mysql/server-5.6/bin/ndb_mgmd –initial –ndb-nodeid=49 –config-dir=/home/sql/MySQL_Cluster/49/ –config-file=/home/sql/MySQL_Cluster/49/config.ini
    11 /opt/mysql/server-5.6/bin/ndb_mgmd –initial –ndb-nodeid=52 –config-dir=/home/sql/MySQL_Cluster/52/ –config-file=/home/sql/MySQL_Cluster/52/config.ini

    12 /opt/mysql/server-5.6/bin/ndbmtd –ndb-nodeid=1 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,
    13 /opt/mysql/server-5.6/bin/ndbmtd –ndb-nodeid=2 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    10 /opt/mysql/server-5.6/scripts/mysql_install_db –no-defaults –datadir=/home/sql/MySQL_Cluster/55/ –basedir=/opt/mysql/server-5.6/
    10 /opt/mysql/server-5.6/bin/mysqld –no-defaults –datadir=/home/sql/MySQL_Cluster/55/ –tmpdir=/home/sql/MySQL_Cluster/55/tmp –basedir=/opt/mysql/server-5.6/ –socket=/home/sql/MySQL_Cluster/55/mysql.socket –port=3306 –ndbcluster –ndb-nodeid=55 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    10 /opt/mysql/server-5.6/scripts/mysql_install_db –no-defaults –datadir=/home/sql/MySQL_Cluster/56/ –basedir=/opt/mysql/server-5.6/
    10 /opt/mysql/server-5.6/bin/mysqld –no-defaults –datadir=/home/sql/MySQL_Cluster/56/ –tmpdir=/home/sql/MySQL_Cluster/56/tmp –basedir=/opt/mysql/server-5.6/ –socket=/home/sql/MySQL_Cluster/56/mysql.socket –port=3307 –ndbcluster –ndb-nodeid=56 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    11 /opt/mysql/server-5.6/scripts/mysql_install_db –no-defaults –datadir=/home/sql/MySQL_Cluster/57/ –basedir=/opt/mysql/server-5.6/
    11 /opt/mysql/server-5.6/bin/mysqld –no-defaults –datadir=/home/sql/MySQL_Cluster/57/ –tmpdir=/home/sql/MySQL_Cluster/57/tmp –basedir=/opt/mysql/server-5.6/ –socket=/home/sql/MySQL_Cluster/57/mysql.socket –port=3306 –ndbcluster –ndb-nodeid=57 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    11 /opt/mysql/server-5.6/scripts/mysql_install_db –no-defaults –datadir=/home/sql/MySQL_Cluster/58/ –basedir=/opt/mysql/server-5.6/
    11 /opt/mysql/server-5.6/bin/mysqld –no-defaults –datadir=/home/sql/MySQL_Cluster/58/ –tmpdir=/home/sql/MySQL_Cluster/58/tmp –basedir=/opt/mysql/server-5.6/ –socket=/home/sql/MySQL_Cluster/58/mysql.socket –port=3307 –ndbcluster –ndb-nodeid=58 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    When I try to run that in that sequence, the multi-threaded servers on servers 12 and 13 won’t start.

    Thanks for your help on this, I really appreciate it

    • andrew says:

      Hi Damian,

      What error are you seeing when you try starting the data nodes?

      What do you see when you run ndb_mgm ?

      Andrew.

  10. Damian says:

    Hello again Andrew,

    I’m getting stuck on this two

    12 /opt/mysql/server-5.6/bin/ndbmtd –ndb-nodeid=1 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,
    13 /opt/mysql/server-5.6/bin/ndbmtd –ndb-nodeid=2 –ndb-connectstring=10.211.55.10:1186,10.211.55.11:1186,

    After I run those lines, the server turn yellow on the auto-installer, but then they go red and off. There is no error on the terminal, but no process will start either. If I deploy and start the server, I see no troubles with it.

    Kind regards

    • andrew says:

      Damian,

      you should take a look at the log files. There should be a Cluster log under the data directory, under the id of the management node and there should also be node log and error file under the id of each of the data nodes (in both cases, local to the machine where that node is meant to be running).

      A common error is that a firewall is stopping the data nodes communicate with the management nodes and/or each other. Try turning off the firewalls on all of the hosts to see if that fixes things.

      Andrew.

  11. wangxin says:

    为什么我的输入mysql进不去 8081 网页http://168.42.8.27:8081/

    • andrew says:

      wangxin – are you trying to connect with the URL that was displayed when you ran the setup command – if not then that’s probably your problem? You can change the server name in the URL by using the -N option when running the setup executable.

      Andrew.

  12. Damian says:

    Hello Andrew

    Thanks for your help but after reading the logs I couldn’t find something useful. Probably the way I’m following the command list is why the nodes won’t start.

    I think I will wait until next version when MaxNoOfAttributes is added on the advance mode and use a different method for the moment. Btw, when do you think it could be there? next beta release maybe?

    Thanks for your help again

  13. chalerm says:

    Hello Andrew

    I get this error when trying the autoinstaller on centos 6.4 with mysql-cluster deployed on 4 machines

    ” cannot locate ndb_mgmd in /usr/local/src/['bin','sbin','scripts',"",'../script] on 192.168.10.4 “

    • andrew says:

      On the second main screen of the installer (the one after you’ve specified the hosts) you’re given the option of specifying where the Cluster binaries are located on each host – have you checked that this was set correctly?

  14. Petri says:

    I’m getting the following error on the Define Hosts page. There are two other identical server builds in the defined cluster that register as OK, while this one fails.

    There were errors when connecting to remote hosts:

    Host ‘mydb1.example.com’: Command `cmd.exe /c echo %OS% %PROCESSOR_ARCHITECTURE%’, running on mydb1.example.com exited with 127:
    sudo: sorry, you must have a tty to run sudo
    bash: cmd.exe: command not found

    Press ‘OK’ to continue to the next page anyway, or ‘Cancel’ to stay at the previous page

    Can you suggest what might be causing this issue? Thanks.

    • andrew says:

      Petri,

      Have you checked that you’re able to sash to that host from the one running the auto installer (using the same credentials)? If that was the first time you’d tried then run the auto installer again to see if it now works.

      Andrew.

  15. Sara Borghol says:

    After opening the web browser and clicking on “create new MySQL cluster”, and getting in the “define cluster” page , I write the IP of the remote server that will hold MySQL database in the “host list” field ,but I get error which say “there were errors when connecting to the remote hosts, host 192.168.119.134: couldn’t open socket to 192.168.119.134,press’ok to continue to the next page anyway, or cancel to stay in the previous page”

    what is the cause of this error and how to solve it?

    • andrew says:

      Hi Sara,

      if you haven’t done so already, connect to each of the target hosts using an ssh client from the machine running the auto-installer. There’s an issue which can mean that the ssh from the installer fails if you haven’t done that.

      Regards, Andrew.

  16. NCH says:

    Hi Andrew,

    This is the status of my cluster.

    [root@db03 /root]# ndb_mgm -e show
    Connected to Management Server at: localhost:1186
    Cluster Configuration
    ———————
    [ndbd(NDB)] 2 node(s)
    id=1 @192.168.100.83 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0, Master)
    id=2 @192.168.100.84 (mysql-5.6.11 ndb-7.3.2, Nodegroup: 0)

    [ndb_mgmd(MGM)] 2 node(s)
    id=49 @192.168.100.93 (mysql-5.6.11 ndb-7.3.2)
    id=52 @192.168.100.94 (mysql-5.6.11 ndb-7.3.2)

    [mysqld(API)] 8 node(s)
    id=50 (not connected, accepting connect from 192.168.100.93)
    id=51 (not connected, accepting connect from 192.168.100.93)
    id=53 (not connected, accepting connect from 192.168.100.94)
    id=54 (not connected, accepting connect from 192.168.100.94)
    id=55 @192.168.100.93 (mysql-5.6.11 ndb-7.3.2)
    id=56 @192.168.100.93 (mysql-5.6.11 ndb-7.3.2)
    id=57 @192.168.100.94 (mysql-5.6.11 ndb-7.3.2)
    id=58 @192.168.100.94 (mysql-5.6.11 ndb-7.3.2)

    I tried to create database in .93, i can see it in .94, but when i create table or insert data in .93, it doesn’t get replicated to .94.

    Any idea why it doesn’t sync to all nodes?

    Thanks.

  17. NCH says:

    I found out the issue, the engine type of the table was InnoDB, once i changed it to NBDCLUSTER, it synced now. :)

    • andrew says:

      NCH,

      sorry for the delay in responding – this is exactly what I was going to suggest you check – InnoDB tables will always be local to a MySQL Server.

      Andrew.

  18. Ramzy says:

    Hi there,

    it seems there is a serious blocking issue while installing on windows 7 – 64 bits) .

    i keep having the following error on the web browser : ” cannot locate ndb_mgmd in C:/NewSofts/mysql-cluster-gpl-7.3.2-winx64/bin//['bin','sbin','scripts',"",'../script] on 127.0.0.1

    for the record i extracted the binary to the following path “C:/NewSofts/mysql-cluster-gpl-7.3.2-winx64″ which i can access with no trouble!

    Any idea about the real problem behind this?

    • andrew says:

      Hi Ramzy,

      Have the binaries been extracted to “C:/NewSofts/mysql-cluster-gpl-7.3.2-winx64″ on all of the hosts that you’re trying to include in the Cluster? If not then you need to do so (or specify the correct path) as the installer will not copy the binaries accross.

      Regards, Andrew.

      • andrew says:

        Hi Ramzy,

        looking at the error message – I wonder, have you set the directory to “C:/NewSofts/mysql-cluster-gpl-7.3.2-winx64/bin” rather than “C:/NewSofts/mysql-cluster-gpl-7.3.2-winx64″?

        Andrew.

  19. Lostcor says:

    Hi,andrew
    I have been stucked in figure 2 ,I try many times ,but it always show failed.
    OS Version: Windows7 32bit
    My cluster Version:7.3 msi

    in figure 1,I set it default value

    Cluster name :mycluster
    Host list :127.0.0.1
    Application area :simple testing
    Write load:low

    i have some questions about i
    1.before i install mysql cluster ,should i install mysql server 、python 、pycrypto etc
    PS。The doc says if use windows msi ,these have been included
    2.MySQL Cluster data directory ,Should i creat it on windows ? i haven’t found it

    Thanks

    • andrew says:

      Hi Lostcor,

      I’ve run on Windows 7 without issues in the past and I’ve just confirmed that using the MSI works ‘out-of-the-box’ (i.e. no need to install any extra components on a fresh Windows 8.1 install). Could it be a firewall issue?

      It will create your datadir for you as part of the auto-install.

      Regards, Andrew.

      • Lostcor says:

        Hi,Andreww
        Sorry for the delay in responding.I try it on the windows 7,it still shows failed.and shows a error “out of the index of list”.And i have a problem with ssh.Should i install a ssh server on the local machine when i use host :127.0.0.1?

        Regards,Lostcor.

  20. Kim says:

    Hi, I am doing cluster database for my Final Year Project. It will be use for a small scale. I am totally new to this but I want to make use of MySQL Cluster and it is running on Ubuntu.

    My plan is using 5 host:
    172.16.90.21 – Management node
    172.16.90.22 – Application node
    172.16.90.23 – Application node
    172.16.90.24 – Data node
    172.16.90.25 – Data node

    My questions are:
    1) Are my planned node setup above correct?
    2) Is it a must to use the multi-threaded data node?
    3) What to do when I received the error “failed to allocate node id….”?

    Thanks.

    • andrew says:

      Hi Kim,

      I answered most of your questions against your later comment but yes, that configuration looks good *but* I’d save on a machine and move your management node to share with one of the MySQL Servers.

      Regards, Andrew.

  21. sai says:

    hi andrew

    I have setup a cluster with disk based tables, with 2 datanodes ,one mgmt , and 2 sql nodes.

    Cluster is working fine… So I just wanted to test its HA , so I manually killed one datanode with KILL command at a linux prompt and I connected to sql nodes and inserted some records into a table.

    I then tried to start datanode which I killed with this command

    bin/ndbd without using any –initial

    When I see the logs on managmnt node it shows the below error and data node is not starting:

    /Node 3: Forced node shutdown completed. Occurred during startphase 5. Caused by error 2355: ‘Failure to restore schema(Resource configuration error). Permanent error, external action needed’.

    But when I use –initial it starts then it means to do a clean start from start (which will be time consuming to copy all the data files what if we have 100G ?)

    But I want the data node to start copying the record from the point it stopped (killed)

    How do I do this? pls help

    • andrew says:

      Sai – you should normally be able to restart the process without –initial, I’m guessing that you must have killed the process as it was writing to disk and corrupted a file.

      Andrew.

  22. Ancient Custodian says:

    Running Auto installer with MySQL Cluster Installation Directory at /usr/sbin. however i receive under mentioned error. deploye and start cluster process reaced to 80% and this error arise. any idea where my-default.cnf should be, or how we can resolve this.
    ————————————————————————
    Command ‘/usr/sbin/mysql_install_db –no-defaults –datadir=/root/MySQL_Cluster/53/ –basedir=/usr/sbin/’, running 10.1.254.32 exited with 1:Fatal Eroor: could not find my-default.cnf

    if you compiled from source, you need to run ‘make install’ to copy the software into the correct location ready for operations.

    if you are using a binary release, you must either be at the top level of the extracted archive, or pass the basedir option pointing to that location.
    ————————————————————————

    • andrew says:

      Could you please provide the output from ls /usr/sbin/ on 10.1.254.32?

      What operating system is this running on?

      Thanks, Andrew.

      • Ancient Custodian says:

        Thankfull to you Andrew for taking interest in my problem. here listed below are the /usr/sbin contents, and linux version

        Linux Version———
        RedHat Linux Server Release 6.4 (Santiago)
        Kernel 2.6.32-358.el6.x86_64

        /usr/sbin——

        Abrtd,
        abrt-dbus
        abrt-install-ccpp-hook
        abrt-server
        accept
        accton
        acminfo
        acpid
        addgnupghome
        adduser
        alsactl
        alsa-delay
        alternatives
        anacron
        apachectl
        applygnupgdefaults
        apxs
        arpd
        arping
        atd
        atrun
        authconfig
        authconfig-gtk
        authconfig-tui
        automount
        avahi-autoipd
        avcstat
        biosdecode
        bonobo-activation-sysconf
        brctl
        build-locale-archive
        cacertdir_rehash
        capsh
        certmonger
        chat
        chpasswd
        chroot
        cifs.idmap
        cifs.upcall
        cimauth
        cimconfig
        cimprovagt
        cimreparchive
        cimserver
        cimservermain
        cimshutdown
        cimtrust
        cimuser
        ck-log-system-restart
        ck-log-system-start
        ck-log-system-stop
        clockdiff
        config.ini
        console-kit-daemon
        convertquota
        cpufreq-bench
        cpuspeed
        cracklib-check
        cracklib-format
        cracklib-packer
        cracklib-unpacker
        create-cracklib-dict
        crond
        cupsaccept
        cupsaddsmb
        cupsctl
        cupsd
        cupsdisable
        cupsenable
        cupsfilter
        cupsreject
        dmidecode
        dnsmasq
        dump-acct
        dump-utmp
        e2freefrag
        edac-ctl
        edquota
        efibootmgr
        eject
        ethtool
        exportfs
        fdformat
        filefrag
        firstboot
        foomatic-addpjloptions
        foomatic-cleanupdrivers
        foomatic-extract-text
        foomatic-fix-xml
        foomatic-getpjloptions
        foomatic-kitload
        foomatic-nonumericalids
        foomatic-preferred-driver
        foomatic-printermap-to-gutenprint-xml
        foomatic-replaceoldprinterids
        genhomedircon
        getcap
        getenforce
        getpcaps
        getsebool
        glibc_post_upgrade.i686
        glibc_post_upgrade.x86_64
        gpm
        groupadd
        groupdel
        groupmems
        groupmod
        grpck
        grpconv
        grpunconv
        gss-server
        hald
        htcacheclean
        httpd
        httpd.event
        httpd.worker
        httxt2dbm
        hwclock
        hwstamp_ctl
        iconvconfig
        iconvconfig.i686
        iconvconfig.x86_64
        ifdhandler
        ifdproxy
        in.authd
        in.fingerd
        in.ntalkd
        inputattach
        in.rexecd
        in.rlogind
        in.rshd
        in.talkd
        in.telnetd
        ipa-client-automount
        ipa-client-install
        ipa-getkeytab
        ipa-join
        ipa-rmkeytab
        ipsec
        irqbalance
        kppp
        krb5-send-pr
        latencytop
        latencytop-tui
        lchage
        lcp_crtpconf
        lcp_crtpol
        lcp_crtpol2
        lcp_crtpolelt
        lcp_crtpollist
        lcp_mlehash
        lcp_readpol
        lcp_writepol
        ldattach
        ledctl
        ledmon
        lgroupadd
        lgroupdel
        lgroupmod
        lid
        lnewusers
        lnstat
        load_policy
        lockdev
        logrotate
        logwatch
        lokkit
        lpadmin
        lpasswd
        lpc
        lpc.cups
        lpinfo
        lpmove
        lsmsr
        lsof
        lsusb
        luseradd
        luserdel
        lusermod
        makedumpfile
        makewhatis
        matchpathcon
        mcelog
        memcached
        mkdict
        mklost+found
        mksock
        modem-manager
        mountstats
        mtr
        my-default.cnf
        mysql
        mysqld
        mysqld-debug
        mysql_install_db
        ndbd
        ndb_mgmd
        ndbmtd
        netscsid
        NetworkManager
        newusers
        nfsidmap
        nfsiostat
        nfsstat
        nstat
        ntpd
        ntpdate
        ntpdc
        ntp-keygen
        ntpq
        ntptime
        ntsysv
        oddjobd
        openct-control
        open_init_pty
        ownership
        packer
        parse_err
        pcscd
        pethtool
        phc2sys
        pifconfig
        ping6
        pluginviewer
        plymouth-set-default-theme
        pmc
        pm-hibernate
        pm-powersave
        pm-suspend
        pm-suspend-hybrid
        postalias
        postcat
        postconf
        postdrop
        postfix
        postkick
        postlock
        postlog
        postmap
        postmulti
        postqueue
        postsuper
        pppd
        pppdump
        pppoe-discovery
        pppstats
        prelink
        ptp4l
        pwck
        pwconv
        pwunconv
        quota_nld
        quotastats
        raid-check
        rcmysql
        readprofile
        redhat_lsb_trigger.x86_64
        reject
        repquota
        repupgrade
        restorecond
        rhn-channel
        rhn_check
        rhn-migrate-classic-to-rhsm
        rhn-profile-sync
        rhn_register
        rhnreg_ks
        rhnsd
        rotatelogs
        rpcdebug
        rpc.gssd
        rpc.idmapd
        rpcinfo
        rpc.mountd
        rpc.nfsd
        rpc.rquotad
        rpc.rstatd
        rpc.rusersd
        rpc.svcgssd
        rtacct
        rtcwake
        rtkitctl
        run_init
        rwhod
        sa
        safe_finger
        saned
        sasl2-shared-mechlist
        saslauthd
        sasldblistusers2
        saslpasswd2
        selinuxconlist
        selinuxdefcon
        selinuxenabled
        semodule
        sendmail
        sendmail.postfix
        sestatus
        setcap
        setenforce
        setquota
        setsebool
        setup
        sfcbd
        showmount
        sim_server
        skdump
        sktest
        smartctl
        smartd
        sm-notify
        smtp-sink
        smtp-source
        snmpd
        snmptrapd
        sosreport
        spacewalk-channel
        spice-vdagentd
        ss
        sserver
        sshd
        sss_cache
        sssd
        start-statd
        subscription-manager
        subscription-manager-gui
        suexec
        system-config-authentication
        system-config-keyboard
        system-config-network
        system-config-network-cmd
        system-config-network-tui
        sys-unconfig
        tb_polgen
        tcpd
        tcpdump
        tcpslice
        tcsd
        test
        testsaslauthd
        thin_check
        thin_dump
        thin_restore
        tickadj
        tmp
        tmpwatch
        togglesebool
        tpmnv_defindex
        tpmnv_getcap
        tpmnv_lock
        tpmnv_relindex
        tracepath
        tracepath6
        try-from
        tunctl
        tunelp
        txt-stat
        tzdata-update
        unsquashfs
        update-alternatives
        update-pciids
        update-reader.conf
        update-smart-drivedb
        useradd
        userdel
        userhelper
        usermod
        usernetctl
        uuidd
        uuserver
        vigr
        vipw
        virt-what
        visudo
        vpddecode
        warnquota
        winbindd
        wpa_cli
        wpa_passphrase
        wpa_supplicant
        x86info
        xinetd
        ypbind
        yppoll
        ypserv_test
        ypset
        yptest
        yum-complete-transaction
        yumdb
        zdump
        zic

        • andrew says:

          It looks as though the file it’s saying it can’t find is there. Does the user you’re using (the one you specify within the auto-installer) have read/write permissions for the folder?

          I guess that you’re using the RPMs for the installation – I confess that I always tend to just use tha tar balls and I haven’t seen this error.

          Andrew.

          • Ancient Custodian says:

            Andrew
            i thankful again for a timely response, obviously i am using RPMs, and using root user for running this setup.

            what i have conceived from your reply is that i should use surce and compile it on my platform.

            Irfan

          • andrew says:

            I’d start by using the binary tar ball – should be no need for you to compile it yourself.

            Andrew.

  23. andrew martin says:

    Great tutorial but it’s just not working for me. the error i’m getting is..

    Cannot locate ndb_mgmd in /storage/mysql/['bin', 'sbin', 'scripts', '', '../scripts'] on host 10.68.116.178

    So to answer some of the questions i’m sure you will have.
    yes i have unpacked the tar ball in /storage/mysql/
    this is the tar i am using mysql-cluster-gpl-7.3.3-linux-glibc2.5-x86_64.tar.gz

    any insight you might have would be great help.
    thanks

  24. Mo says:

    Hi Andrew,

    Im new to MySql Cluster. Im using the MySql Cluster Installer and when i try to deploy the cluster i get “unable to create directory c:/xx/52/ on host xx.xx.xx.xx: EOFError ()

    setup is as follows;
    Node 1
    management node 1
    Sql node 1

    node 2
    management node 2
    sql node 2

    node 3
    Multi threaded data node 1

    node 4 multi threaded data node 2

    runninng on W2K12

    thanks mo

    • Mo says:

      Ive managed to get the installer to deploy the cluster but it now comes up with Command’[u'net','start','N49']‘ returned non-zero exit status 2

    • andrew says:

      Does the user account you’ve specified in the auto-installer have read/write permissions for “c:/xx/52/ on host xx.xx.xx.xx”?

      Andrew.

      • andrew says:

        Also make sure that you’ve already been able to manually ssh from the auto-installer machine to each of the target machines (as you need to get past the point where ssh asks you if you’re sure that you want to allow connections to these machines – the auto-installer doesn’t handle that).

        Andrew.

        • Mohammad says:

          Hi andrew
          I used MySQL Cluster installer in windows. should I install ssh on windows. and I have just one host and that is 127.0.0.1 which is localhost. I did this just for exam to install it.

  25. Dainiax says:

    Hello,
    I installed cluster on Ubuntu server from *.deb package. Cd to /opt/mysql/server-5.6/bin and run ndb_setup.py It says to navigate to http://localhost:8081/welcome.html, but how to run this on external browser, e.g. server_external_ip:8081/welcome.html ?

    Thank you

  26. yogesh says:

    Hello Sir,
    1) I am trying to create cluster on my windows 7 32 bits machine,i have downloaded Auto-Installer from this site..(http://dev.mysql.com/downloads/cluster/) in zip mode..(Windows (x86, 32-bit), ZIP Archive 7.3.3,343.8M)

    2)after that i have unzip this and rename it with mysql ,into c drive called mysql,it looks like this -> C:\\mysql

    3)after this i double click on setup.bat file

    thanks…..
    4)it opens command prompt(cmd) then automatically redirect me to the following page -> http://pc1:8081/content.html

    5)then on welcome page i click on create on new mysql cluster

    6)i entered host like 192.168.1.1,192.168.1.2,192.168.1.8,192.168.31.9

    7)after when i click next on select and edit host -> it only run my first ip address or host and other failed to connect.

    till i am done mysql cluster installation part but why i am getting error or failed to connect to other machines,plz tell me

    is it necessary to run setup.bat on every machine. if yes then plz tell me process.

    • andrew says:

      yogesh,

      there’s no reason to run setup.bat on each machine.

      On the page where you specify the target hosts, you also get the chance to specify the user and password that will be used for the ssh connections to all of the target machines. Have you made sure that the user you’ve specified has permissions on all of those target machines?

      Andrew.

  27. Chris says:

    Hi Andrew,

    I’m getting the same thing Mo is getting: Command’[u'net','start','N49']‘ returned non-zero exit status 2
    when I click the “Deploy and start cluster”
    If I choose the “Deploy cluster” button I get no errors.

    I am doing a default install of MySQL cluster 7.3.3 win x64. I have MySQL 5.6.13 installed and operating on the same machine.

    Any idea how to work around this error?

    Thanks, –Chris

    • andrew says:

      Chris,

      Does the user account you’ve specified in the auto-installer have read/write permissions for the directories that are being accessed on the target machines?

      Andrew.

      • andrew says:

        Also make sure that you’ve already been able to manually ssh from the auto-installer machine to each of the target machines (as you need to get past the point where ssh asks you if you’re sure that you want to allow connections to these machines – the auto-installer doesn’t handle that).

        Andrew.

        • Chris says:

          Thank you for your help Andrew! The default install for testing attempts to put everything on the same machine so I am sure I have read/write permissions on the directories involved. I have bitvise ssh server installed on the machine an it tests out OK with Putty with the user I am using to attempt the instal(I don’t know if it is even necessary when installing the test system on one machine).

  28. Beck says:

    Command’[u'net','start','N49']‘ returned non-zero exit status 2

    I don’t know what SSH is, I have used mysql in the past and this new version is way different than what I am used too. I am only using it as database for one program. This is too complex for me, where can I get an older version?

    • andrew says:

      Hi Beck,

      if you’re used to configuring MySQL Cluster in the old way then that’s still possible – the auto-installer just presents a simpler front-end for those people not already comfortable with MySQL Cluster.

      Regards, Andrew.

      • Mark says:

        I have the same error [Command’[u'net','start','N49']‘ returned non-zero exit status 2] during my first installation and have no idea what’s causing it.

        • andrew says:

          Hi Mark,

          have you followed the steps of checking:

          • That the referenced folders exist on the target machines and are read-writeable by the SSH user you’re using?
          • That you’ve been able to SSH manually from the Windows machine running the installer to the target machines?

          On the last screen – what are the commands that it shows will be executed?

          How far does it get before it fails (are some of the processes shown in green)?

          Regards, Andrew.

          • Mark says:

            Hi Andrew,
            * Yes, the referenced folders exist.
            * What’s the SSH user?
            * How do I SSH manually?

            I’m installing MySQL and the database on the one server (PC). I’ve tried 127.0.0.1 and the LAN IP address. I’ve tried giving everyone full access to the data path.

            Thanks,
            Mark

          • andrew says:

            If everything is on the same local machine then you shouldn’t need to worry about the ssh credentials.

            Any errors or warnings in any of the log files?

          • Mark says:

            I can’t find any log files. Are they called .log? I’ve searched all MySQL folders but it hasn’t created any log files that I can find.

            When clicking on the Deploy and Start the process runs about 1/10th of the way until it gets to N49 then shrinks back and displays the error.

          • andrew says:

            Hi Mark,

            let’s narrow down the problem.

            On the page after specifying the host (presumably you left it as “localhost”?), if things are working properly then you should have seen that the auto-installer automatically discovered information about the machine and chose some default paths. On my machine, I have these:
            MySQL Cluster Install directory: C:\Users\anmorga\Documents\mysql_loads\mysql-cluster-gpl-7.3.2-winx64\
            MySQL Cluster data directory: C:\Users\anmorga\MySQL_Cluster\

            what do you have?

            When you get to the last page, you can click on the individual process/nodes to see what command will be executed to start the processes and what (if any) the config files look like.

            For example, for the management_node I have the following:

            Host 127.0.0.1
            Path C:/Users/anmorga/Documents/mysql_loads/mysql-cluster-gpl-7.3.2-winx64/
            Executable ndb_mgmd.exe
            Options --initial--ndb-nodeid=49--config-dir=C:\Users\anmorga\MySQL_Cluster\49\--config-file=C:\Users\anmorga\MySQL_Cluster\49\config.ini

            What do you see?

            After you click the button to deploy and start the Cluster, a “Starting Cluster” pop-up should appear which will update with the latest stage of the process – what’s the last message you see in there before things start to go wrong?

            The Cluster log and error files are located within the cluster folders – each node has a sub-folder named after its node id. For example for my management node I have C:\Users\anmorga\MySQL_Cluster\49\ndb_49_cluster.log and C:\Users\anmorga\MySQL_Cluster\49\ndb_49_out.log – if there’s been a problem you may also see an error log in there. For one of my data nodes I have C:\Users\anmorga\MySQL_Cluster\1\ndb_1_out.log and for a MySQL Server C:\Users\anmorga\MySQL_Cluster\53\ANMORGA-GB.err

            Note that you can also run setup-debug.bat rather than setup.bat which might give you some extra information.

            Please let me know what you fnd so that I can comment on what to try next.

            Regards, Andrew.

          • Mark says:

            Hi Andrew,
            Sorry it has taken a while to get back to you. In my frustration I have decided to simplify the MySQL installation by moving away from the Cluster version and gain some skill in the simple version first, then I will come back to Cluster some time in the future.

            Thanks for your help to this point.

            PS. I never did get a log file output.

            Mark

  29. Boban Bukarica says:

    Hi Andrew and rest of the people !

    For everyone having trouble starting Cluster for the first time and getting [Command’[u'net','start','N49']‘ returned non-zero exit status 2] error , try to run setup.but with right click .. run as administrator .

    Doesn’t matter if user is admin , or has access to the cluster directories on HD , the issue for me was that services could not start properly and hence the error above .

    Just lost a loooot of time trying to figure it out

    regards,
    Boban

  30. Dustin says:

    Hi Andrew. You appear to be doing a great job helping individuals, so I’m hoping you might be able to provide me some guidance. I am getting the below error while setting up MySQL Cluster on a pair of Linux servers. I’m fairly new to working with servers, so I may be overlooking something simple. We have two physical servers each running two virtual managers. The second VM of each physical is to be our database Cluster (that way if one server is off, the other steps in). The operating system is CentOS 6.5, and we can call the user ‘adminuser’. He should have full access to the system.

    Error message: Command ‘/home/adminuser/MySQL_Cluster_7.3.4/bin/ndbmtd–ndb-nodeid=1–ndb- connectstring=MyIPaddress:1186,’,running on MyIPaddress exited with 1.
    timestamp [ndbd] INFO ‘–Angel connected to ‘MyIPaddress:1186′
    timestamp [ndbd] ERROR –Failed to allocate nodeid, error: ‘Error:Could not alloc node id at MyIPaddress port 1186: Id 1 already allocated by another node.’

    Note: The system is on an internal server with no internet connection.

    Install Settings: Application area is ‘web application’ with medium write load. Username is ‘adminuser’ with password. Host list is the IP address of the two virtual servers. Server 1 has a management node, 2 API nodes, an SQL node, and a multi-threaded data node. Server 2 has 2 API nodes, an SQL node, and a multi-threaded data node.

    • andrew says:

      Is it possible that you still have processes running from an earlier attempt to run MySQL Cluster? The error is telling us that you already have a process that’s part of the cluster with an ndb-nodeid of 1. In the auto-installer, is it using a node-id of 1 for more than one node/process?

      Andrew.

      • Dustin says:

        It is possible something was hanging from a previous install. I deleted the folders, but a process could have been stuck. I restarted the system in order to clear everything out and start again.
        However, I am now unable to ‘import remote host’ on the Define Host screen. I’ve tried with my adminuser and root. I was able to ssh into the other machine using the IP address and credentials. Any thoughts on how to proceed?

        It does not appear any other node is using the id of 1. Each node has a unique id.

        • Dustin says:

          I was able to solve the ‘import remote host’ issue, and am not receiving the ‘node in use’ message at the moment.

          However, I am getting a message ‘Cannot locate mysql_install_db in “/home/adminuser/MySQL_Cluster/[‘bin’, ‘sbin’, ‘scripts’…”

          MySQL_Cluster is the location of the extracted tar files, but mysql_install_db does not appear to be in it. Is this something i need to download in addition?

          Thanks again for the help.

          • Dustin says:

            Sorry for another update. Our hard drive on that server died, and we had to replace it and start over.

            My current situation is I get an error on ‘Deploy and Start Cluster’ stating “fatal error….find out how to run mysqldb as root!”

            I’ve disabled our firewall, my adminuser has sudo privilages. I’ve also attempted the install with both ‘python ndb_setup’ and ‘sudo python ndb_setup’ with the same message both times.

  31. Chris says:

    Hi Again Andrew.
    I am still (2 months later) trying to get MySQL Cluster installed and working (win 7 64 bit). When I use the setup.bat and get to ‘deploy and start cluster’ I get “Unable to create directory C:/MySQL/Data/52 on host 192.168.100.14: The requested operation failed”. I have Bitvice SSH server and Putty on all 4 machines and have tested connecting, writing, creating directories and files from each machine to the others with no problem using the user account I specify in the initial dialog.

    I created all of the directories an checked the permissions and even added ‘Authenticated Users’ with full control to C:\MySQL and it’s subdirectories. It REALLY seems like a permissions problem but I have no idea what more to do. Does the user that deploys the cluster need “log on as batch job” or something like that?

  32. Chris says:

    Thanks Andrew,

    I tried freeSSHd but could not connect. I found that this is a known issue on win64 when it is run as a service. I then tried copSSH and can connect and write files and create directories (the commands are unix-like as opposed to the bitvice SSH server I was using before which used dos commands, still using Putty to test).
    Bombed again in the same place: “Unable to create directory C:/MySQL/Data/52 on host 192.168.100.14, but there is more to the error this time. It continues:
    Command ‘uname -sp’, running on 192.168.100.14 exited with 127:
    bash: uname: command not found
    perhaps yet another SSH server?

  33. Chris says:

    Andrew, I tried openSSH, copSSH, and bitvise SSH servers with no luck. I tried freeSSHd as you suggest but selected not to have it create a service (so I have to manually start it). when I get to “deploy and start cluster” it errors out with “Unable to create directory C:/user/kyburg/MySQL_cluster/52/ on host 192.168.100.14:[Errno 13] Permission denied”

    I can use putty, log on with the same account I am providing the setup.bat, create the directory without a problem. I rerun the install and it stops at the same place with the same error.

  34. Chris says:

    Hi Andrew,

    just another data point for you. I am able to get MySQL cluster running following the instructions from http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-install-windows-initial-start.html
    I would really like to get to the bottom of why the GUI does not work on my machines though. They are virtual machines created and managed with VMware vsphere.

  35. Wolfgang says:

    Hi Andrew, I am trying to install the mysql CGE 7.3 on a Win 2012 Server 64bit, downloaded and extracted all packages. Double-Clicking setup.bat starts the browser and presents welcome page. Clicking on “Create new Cluster” jumps to the next page, but this page is simply EMPTY, no wizard is showing up. Navigating manually to the page as suggested brings the same result. No error messages in browser or DOS window opened by the setup, no windows events. How can I fix this problem? I am using IE10 and already minimized security settings, deactivated Win-Firewall, all without any luck. Still second page after clicking “Create new Cluster” jumps to page called “content.html”, but there is no wizard showing up, just the blue frame and “Oracle Cluster Installer” heading, no content :-(
    Thanks for your support

    • andrew says:

      Hi Wolfgang,

      if you’re able to run a different browser on the target machine then I’d try that (I know that IE can be very restrictive on what it allows on Windows Server.

      The other thing to try is running setup.bat -n -N and then use the URL you’re given from a desktop machine where the browsers are less restricted.

      Andrew.

      • Wolfgang says:

        Hi Andrew,
        thanks for your quick feedback. Indeed IE on MS-Server 2012 seems very restrictive by default. I downloaded FF and quickly checked that the wizard is starting properly. It worked, so I will soon continue with the setup. Thanks for your support!
        Wolfgang.

        • Wolfgang says:

          Hi Andrew,
          I now managed to start the installer and configure the cluster for testing purposes as suggested in the various documents. Finally upon deploying the cluster I receive an error “Command ‘[u'net', 'start', 'N49']‘ returned non-zero exit status 2″. This is similar to the problem posted by Mohammad above. I wonder whether there is a solution for this problem. I am also running the cluster on a single host 127.0.0.1, so missing SSH shouldn’t be a problem. Thanks again for your support!

          • andrew says:

            Boban found the answer to this one….

            For everyone having trouble starting Cluster for the first time and getting [Command’[u'net','start','N49']‘ returned non-zero exit status 2] error , try to run setup.but with right click .. run as administrator .

          • Wolfgang says:

            Thanks Andrew, I am running the script as Domain Administrator already but will check whether running it as local Administrator makes a difference.

          • Wolfgang says:

            Hi Andrew, I now ran the setup as local Server Administrator and ran into the same problem mentioned above. By looking into the Windows Event Log I found the following entry related to the start of the N49 service: “Directory ‘C:/Program’ specified with –configdir does not exist. Either create it or pass the path to an already existing directory..”. I guess it might have something to do with the fact, that the installation directory contains whitespaces (i.e. “Program Files” or “MySql Cluster 7.3″). Any help how to fix this is highly appreciated!

          • Wolfgang says:

            Hi Andrew, I installed everything into a directory structure NOT containing any whitespaces and it seems that the setup is running fine now.

          • andrew says:

            Good to hear :)

            Had you overridden the paths within the installer or just kept the defaults? If the former then maybe escaping the white space would help; if the later then it could be a bug.

            Regards, Andrew.

          • Wolfgang says:

            Hi Andrew, in the “Define Hosts” section of the installer I pasted the cluster install and cluster data directory name copied from the windows explorer (the installer didn’t detect them automatically). If these directories contain whitespaces, then the deployment works but the cluster services do not start. I didn’t try to escape the whitespaces. I tried to use quotes around the directory path but then the deployment already fails. Therefore I moved removed the whitespaces from the installation directory and restarted the setup, which worked out fine. Cluster is now up and running. Am I right with the assumption, that with the open source cluster 7.3.4 the cluster management is command line based, whereas the commercial CGE ships with a management GUI?

          • andrew says:

            If using the community (open source) version of MySQL Cluster then you use command-line tools like ndb_mgm to manage (and monitor) MySQL Cluster. If using the commercial version then you have access to 2 extra tools:

            1. MySQL Cluster Manager – still command-line based but has higher level cluster-wide operations (for example, a single command to upgrade every node in the cluster
            2. MySQL Enterprise Monitor – A MySQL monitoring GUI that also works for MySQL Cluster
          • Wolfgang says:

            Thanks for your very valid feedback and support Andrew! MySql 5.6.15-ndb-7.3.4 is now up and running and I will read through the documentation how to manage and control the configuration (options/parameters).

          • Stefan says:

            On a windows system try to use / instead of the automatically selected \ in all file paths, run setup_debug.exe as admininstrator and delete all services before you try again with the new paths (e.g. sc stop n1, sc delte n1)

  36. Till says:

    Hi Andrew,

    I try to use the cluster auto-installer on 4 Windows server:

    1: 192.168.1.10 Management / SQL
    2: 192.168.1.12 Mutli-threaded
    3: 192.168.1.13 Management / SQL
    4: 192.168.1.14 Mutli-threaded

    I started the install and get following error:

    http://hb-hosting.de/cloud/public.php?service=files&t=8c6f54e15c66043b91cc63e8b037b273

    I do not know where the problem is, the folder link is adapted to Windows and the SSH user is the local admin

    regards

    Till

  37. Joao says:

    Hi Andrew!
    Should i put the mysql cluster folder on every nods!?

  38. emad says:

    hello,
    I am beginner of mysql cluster and using auto installer on windows OS.
    I am facing a problem in the second window (define hosts), failed to connect of all hosts except my machine. the error msg “Error: couldn’t open socket to server ip….”

    may you can help,
    Thanks

  39. Giuseppe Proietti says:

    Hi,

    I got the same issues of Dustin , I get an error on ‘Deploy and Start Cluster’ stating “fatal error….find out how to run mysqldb as root!”

    I’m on a new fresh CentOS 6.5 minimal installation.

    Many thanks

    • andrew says:

      You can’t run MySQL Servers as the hosts root user. Specify a different user for the SSH credentials on the first main page of the installer.

      Best Regards, Andrew.

      • Giuseppe Proietti says:

        Thanks, I solved it.
        The wizard now starts all the nodes.

        ndb_mgm> show
        Cluster Configuration
        ———————
        [ndbd(NDB)] 2 node(s)
        id=1 @192.168.0.105 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
        id=2 @192.168.0.106 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)

        [ndb_mgmd(MGM)] 1 node(s)
        id=49 @192.168.0.104 (mysql-5.6.17 ndb-7.3.5)

        [mysqld(API)] 4 node(s)
        id=50 (not connected, accepting connect from MyCluster-D1)
        id=51 (not connected, accepting connect from MyCluster-D2)
        id=53 @192.168.0.105 (mysql-5.6.17 ndb-7.3.5)
        id=54 @192.168.0.106 (mysql-5.6.17 ndb-7.3.5)

        Only a little question: is it normal that after the pop-pup “Cluster started” is shown, the button “Finish” in the wizard remains in grey status ?

        Many thanks !!!

  40. Shenthilkumar says:

    I try to deploy and start cluster. A message box with “Starting cluster N2″ is open for long time with 42%
    I am waiting for more than 2 hours. But there is no progress.

    Note: Previously, it worked. I stopped the cluster and try to run again

    • andrew says:

      I’d suggest taking a look at the log files on the target machines to see if there are clues there.

      Andrew.

      • Shenthilkumar says:

        I try to re run the cluster today. Still this problem exists.
        I hope, you ask me to check log files in C:\Users\shenthil\MySQL_Cluster\1 and MySQL_Cluster\2\.

        ndb_1_out.log – Angel pid: 6412 started child 2592
        ndb_2_out.log – Angel pid: 7068 started child 7268

  41. Shenthilkumar says:

    I am using cluster for the firs time.

    I have 2 Laptops with Mysql server and workbench installed. Theses laptops are in same work group.
    I want to use cluster. I followed the steps you described above.
    I configure cluster in Laptop A(127.0.0.1), Like in your figure2, My Laptop B IP is failed to discover.
    I guess, this is very basic question.

    1) How can I change my ip 127.0.0.1
    2) How should I enable remote access to Laptop B?

    • andrew says:

      127.0.0.1 is a special IP Address – the loopback address (in otherwords it’s always for the local machine). When you use the installer, just replace it with the IP addresses of your 2 laptops.

      Andrew.

      • Shenthilkumar says:

        Andrew,

        Strange things happen.
        From my home, I replaced 127.0.0.1 to my laptop IP address. It worked fine.
        When I try the same from my office, it doesn’t.
        Since it is not working. I asked my system admin to fix the IP address. Now the IP address for my two laptops are fixed. but still it is nor fetching.

        • Shenthilkumar says:

          In Define Cluster> host list, I entered the IP address of both the laptops

          In Define hosts, I could see both the IPs failed

          • andrew says:

            Are you able to manually ssh from the machine running the auto-installer to each of the target machines Once that’s working, try the auto-installer again.

            Andrew.

          • Shenthilkumar says:

            Andrew,

            I don’t know much about SSH
            I configured freesshd in my laptop.
            I started SSH server.
            What else do I have to do?

          • andrew says:

            You need to have an SSH server running on the target machines (those that will be part of the Cluster); freesshd is an example of an SSH server for Windows; other operating systems (such as Linux) normally have one built in. You then need an ssh client on the machine that you’re running the auto-installer from so that you can create an ssh connection to the target machines (it will ask you permission the first time you connect and you need to get that out of the way before using the auto-installer).

            Andrew.

          • Shenthilkumar says:

            Andrew, I could able to manually ssh from the machine running the auto-installer to each of the target machines

            But still it is failed to fetch both IPs

          • Shenthilkumar says:

            Dear Andrew,

            As you said,
            I installed freesshd in target machine and Putty in my machine(in which I will use Auto installer)
            I could able to connect SSH using PuTTY.
            Please check the below snapshot I sent to your mail ID.
            PuTTY windos shows that I am connected to target machine 10.10.122.11
            But when I specify the target machine IP in Auto installer, it fails.

          • andrew says:

            Did you use the same ssh username and password that you specify in the auto-installer?

            The path of least resisence might be to forget about the remote connections (after all the auto-installer is meant to make things simpler rather than more complex!). Just manually fill in the details for the target machines (after the installer fails to connect) and then at the final screen, rather than hitting the “deploy and start” button, click on each node in turn and it will give you the contents of each config file as well as the commands that you can manually run on the target machines to start the cluster. Start with the management node(s); then the data nodes and finnaly the MySQL servers.

            Andrew.

          • Shenthilkumar says:

            Dear Andrew,

            //Did you use the same ssh username and password that you specify in the auto-installer?//
            In MySQL auto installer, I don’t specify Username & password. I don’t understand which username & password you are talking about. Can you please clear me if I am wrong.

            //////Just manually fill in the details for the target machines (after the installer fails to connect) and then at the final screen, rather than hitting the “deploy and start” button, click on each node in turn and it will give you the contents of each config file as well as the commands that you can manually run on the target machines to start the cluster. Start with the management node(s); then the data nodes and finnaly the MySQL servers.//////

            Where do you ask me to fill the details manually? in Auto installer? or in config file?
            How to start nodes individuall?. That doesn’t work.
            I am struggling with this issue for long time. Can you please come online to fix the problem.

          • andrew says:

            In order for the autoinstaller to interact with the target machines, it needs to use ssh to connect to them. By default it uses ssh certificates that have already been set up on the target machines and the one running the auto-installer. By default, you won’t have those set up. Rather than detailing how to set them up, if you’re new to ssh then it’s easier to just check the box to say that you want to use username/password credentials instead and provide the username/password for the user on the target machines that you would like the MySQL Cluster processes to run under; before doing that, confirm that you can manually ssh to the target machines (from the one that will run the autoinstaller).

            Best Regards, Andrew.

          • Shenthilkumar says:

            Dear Andrew,

            Can you please reply.

          • Shenthilkumar says:

            Yes, I can manually ssh to the target machines (from the one that will run the autoinstaller).

            // if you’re new to ssh then it’s easier to just check the box to say that you want to use username/password credentials instead and provide the username/password for the user on the target machines that you would like the MySQL Cluster processes to run under;//

            Where to check the box? In MySQL Autoinstaller? I could not see the check box. Please help

          • andrew says:

            Yes – in the auto-installer, you should be able to use the check box to allow a username and password to be specified. Is that not happening? What web browser are you using?

  42. Jonas says:

    Hi,

    Andrew

    I have a question, what is the correct directory where you have to configure (MySQL Cluster install directory).

    I am using CentOS 6.5 as OS

    The directory where the Autoinstaller was found / usr / bin / ndb_setup.py. But soon got an error when starting the Cluster ndb_mgmd saying is not found. However I located this file in the / usr / sbin / ndb_mgmd.

    This is where my doubt correct to be configured in MySQL Cluster AutoInstaller directory.

       I’m trying to mount the cluster as follows:

    1. 187.xx.177.49 Cluster MGM
    2. 187.xx.177.51 Cluster MGM
    3. 187.xx.177.48 SQL Node and API
    4. 187.xx.177.52 SQL Node and API

    In all these hosts run MySQL-Cluster-gpl-server-7.3.5-1.el6.x86_64.rpm.

    And from 187.xx.177.49 run MySQL Cluster AutoInstaller / usr / bin / ndb_setup.py.

    Thanks for any help you can.

    Another question, after my cluster ok, exist a web tool to manage this cluster?

    • andrew says:

      My personal preference is to use the generic Cluster tar ball and then you can just point the auto-installer to wherever you’ve extracted the contents.

      Best Regards, Andrew.

    • andrew says:

      btw – note that the ndb_mgmd needs very little resource and so typically people would run the MySQL Servers on those same machines.

      Andrew.

  43. Marcio Oliveira says:

    Hello I’m thinking of putting a MySQL Cluster environment at work I have some more questions about the Auto Install MySQL Cluster. My test environment is as follows:

    Debian Server on all text mode

    1 Node Management: 192.168.56.10
    2 Node SQL and DATA: 192.168.56.11
    3 Node SQL and DATA: 192.168.56.11

    My questions are: I need to be running in Node? SSH, Apache, binaries must be in the same location on both servers, which packages have to be installed?

    • andrew says:

      You’re showing all of your MySQL and data nodes running on the same machine – is that intentional (note that that doesn’t provide any fault tolerance)?

      The auto-installer can be run on one of your target machines or on a different one – it just needs to be able to ssh to each; you don’t need the same directories to be used on all of the machines.

      Best Regards, Andrew.

  44. vijay muddu says:

    hi andrew
    i want to setup mysql cluster from scratch can you help me or suggest me link with step by step instructions

    i want to setup cluster between 2 systems
    also can i keep data & sql node on same system

    thanks
    regards
    vijay

    • andrew says:

      Hi Vijay,

      I was hoping that the blog post (and video) would provide the details needed – are any steps unclear?

      Yes, you can run the MySQL Servers and Data Nodes on the same machines *but* if you want fault tolerance then the management node(s) should run on a 3rd machine – see this blog post for the reason why.

      Best Regards, Andrew.

  45. Xanion says:

    Hi Andrew,

    I have the issue : “Cannot locate ndb_mgmd in /usr/mysql-cluster/['bin', 'scripts', '', '../scripts'] on host 10.0.20.120″
    I executed the auto installer from a windows on 4 linux centos 6 (10.0.20.120,10.0.20.121,10.0.20.122,10.0.20.123).
    You said “extract the tarball in the instalation directory” so I extracted the content of the windows archive (tell me if i wrong) in /usr/mysql-cluster but still don’t work.
    Any idea ?

    Thx you,

    Xanion

    • andrew says:

      Hi Xanion,

      you ned to extract the tar ball on the target machines (Centos in your case) and then specify that location when you work through the auto-installer.

      Best Regards, Andrew.

      • Xanion says:

        Thx for the answer.
        Like I said, I already try extract the tar ball (http://dev.mysql.com/downloads/file.php?id=451711) and I specified the link : /usr/mysql-cluster/ during the installation, but still have the issue.
        The ls of my directory (/usr/mysql-cluster/) :
        bin database lib README setup-debug.bat support-files
        COPYING docs my-default.ini scripts share
        data include mysql-test setup.bat sql-bench

        • andrew says:

          The download link is for Windows – but from the path it looks like the target machines are Linux so you should be extracting the Linux tar ball on those machines.

          Regards, Andrew.

          • Xanion says:

            Thanx again.
            So I downloaded the source code “Generic Linux (Architecture Independent), Compressed TAR Archive”
            but in scripts/ there is not a ndb_mgmd.
            Same for the download Generic Linux “Linux – Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive”.
            Sorry to ask you that but can you give me the link of the tar ball pls ?

            Regards, Xanion.

          • andrew says:

            Looked in the bin directory? In any case, if you point the auto-installer to the root of the directory then it should find what it needs.

            Andrew.

  46. Genfry says:

    Hello,
    i tried to install MySQL cluster on 4 Windows hosts without success.
    user on all hosts is the same with the same password.
    hosts ha

  47. Genfry says:

    Hello,
    i tried to install MySQL cluster on 4 Windows hosts without success.
    user on all hosts is the same with the same password.
    hosts have different name
    I tried with path / or \ in the name too.
    first issue is discovery recognize only the host where I execute the setup.bat file.
    If I set manully the other 3, after it is not able to connect with them.
    I also installed freesshd sw and started it as service, no user/password.
    firewall is disabled on all hosts. each host ping the other hosts.
    what’ wrong ?
    windows server 2008 R2 datacenter
    Mysql cluster 7.3.5

    thank you
    GB

Leave a Reply

Your email address will not be published. Required fields are marked *