Creating a simple Cluster on a single LINUX host

It isn’t necessarily immediately obvious how to set up a Cluster on LINUX; this post attempts to show how to get a simple Cluster up and running. For simplicity, all of the nodes will run on a single host – a subsequent post will take the subsequent steps of moving some of them to a second host. As with my Windows post the Cluster will contain the following nodes:

  • 1 Management node (ndb_mgmd)
  • 2 Data nodes (ndbd)
  • 3 MySQL Server (API) nodes (mysqld)

Downloading and installing

Browse to the MySQL Cluster LINUX download page at mysql.com and download the correct version (32 or 64 bit) and store it in the desired directory (in my case, /home/billy/mysql) and then extract and rename the new folder to something easier to work with…

[billy@ws1 mysql]$ tar xvf mysql-cluster-gpl-7.0.6-linux-x86_64-glibc23.tar.gz
[billy@ws1 mysql]$ mv mysql-cluster-gpl-7.0.6-linux-x86_64-glibc23 7_0_6

Create 3 data folders (one for each of the MySQL API – mysqld – processes) and setup the files that will be needed for them to run correctly…

[billy@ws1 mysql]$ cd 7_0_6/data
[billy@ws1 data]$ mkdir data1 data2 data3
[billy@ws1 data]$ mkdir data1/mysql data1/test data2/mysql data2/test data3/mysql data3/test
[billy@ws1 7_0_6]$ cd ..
[billy@ws1 7_0_6]$ scripts/mysql_install_db --basedir=/home/billy/mysql/7_0_6 --datadir=/home/billy/mysql/7_0_6/data/data1
[billy@ws1 7_0_6]$ scripts/mysql_install_db --basedir=/home/billy/mysql/7_0_6 --datadir=/home/billy/mysql/7_0_6/data/data2
[billy@ws1 7_0_6]$ scripts/mysql_install_db --basedir=/home/billy/mysql/7_0_6 --datadir=/home/billy/mysql/7_0_6/data/data3

Configure and run the Cluster

Create a sub-directory called “conf” and create the following 4 files there:

config.ini

[ndbd default]
noofreplicas=2

[ndbd]
hostname=localhost
id=2

[ndbd]
hostname=localhost
id=3

[ndb_mgmd]
id = 1
hostname=localhost

[mysqld]
id=4
hostname=localhost

[mysqld]
id=5
hostname=localhost

[mysqld]
id=6
hostname=localhost

my.1.conf

[mysqld]
ndb-nodeid=4
ndbcluster
datadir=/home/billy/mysql/7_0_6/data/data1
basedir=/home/billy/mysql/7_0_6
port=3306
server-id=1
log-bin

my.2.conf

[mysqld]
ndb-nodeid=5
ndbcluster
datadir=/home/billy/mysql/7_0_6/data/data2
basedir=/home/billy/mysql/7_0_6
port=3307
server-id=2
log-bin

my.3.conf

[mysqld]
ndb-nodeid=6
ndbcluster
datadir=/home/billy/mysql/7_0_6/data/data3
basedir=/home/billy/mysql/7_0_6
port=3308
server-id=3
log-bin

Those files configure the nodes that make up the Cluster. From a command prompt window, launch the management node:

[billy@ws1 7_0_6]$ bin/ndb_mgmd --initial -f conf/config.ini --configdir=/home/billy/mysql/7_0_6/conf
2009-06-17 13:00:08 [MgmSrvr] INFO     -- NDB Cluster Management Server. mysql-5.1.34 ndb-7.0.6
2009-06-17 13:00:08 [MgmSrvr] INFO     -- Reading cluster configuration from 'conf/config.ini'

Check that the management node is up and running:

[billy@ws1 7_0_6]$ bin/ndb_mgm
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]    2 node(s)
id=2 (not connected, accepting connect from localhost)
id=3 (not connected, accepting connect from localhost)

[ndb_mgmd(MGM)]    1 node(s)
id=1    @localhost  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]    3 node(s)
id=4 (not connected, accepting connect from localhost)
id=5 (not connected, accepting connect from localhost)
id=6 (not connected, accepting connect from localhost)
ndb_mgm> quit

and then start the 2 data nodes (ndbd) and 3 MySQL API/Server nodes (ndbd) and then check that they’re all up and running:

[billy@ws1 7_0_6]$ bin/ndbd --initial -c localhost:1186
2009-06-17 13:05:47 [ndbd] INFO     -- Configuration fetched from 'localhost:1186', generation: 1
[billy@ws1 7_0_6]$ bin/ndbd --initial -c localhost:1186
2009-06-17 13:05:51 [ndbd] INFO     -- Configuration fetched from 'localhost:1186', generation: 1

[billy@ws1 7_0_6]$ bin/mysqld --defaults-file=conf/my.1.conf&
[billy@ws1 7_0_6]$ bin/mysqld --defaults-file=conf/my.2.conf&
[billy@ws1 7_0_6]$ bin/mysqld --defaults-file=conf/my.3.conf&

[billy@ws1 7_0_6]$ bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]    2 node(s)
id=2    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0, Master)
id=3    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0)

[ndb_mgmd(MGM)]    1 node(s)
id=1    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]    3 node(s)
id=4    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6)
id=5    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6)
id=6    @127.0.0.1  (mysql-5.1.34 ndb-7.0.6)
ndb_mgm> quit

Using the Cluster

There are now 3 API nodes/MySQL Servers/mysqlds running; all accessing the same data. Each of those nodes can be accessed by the mysql client using the ports that were configured in the my.X.cnf files. For example, we can access the first of those nodes (node 4) in the following way (each API node is accessed using the port number in its associate my.X.cnf file:

[billy@ws1 7_0_6]$ bin/mysql -h localhost -P 3306
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 4
Server version: 5.1.34-ndb-7.0.6-cluster-gpl-log MySQL Cluster Server (GPL)
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> use test;
Database changed
mysql> create table assets (name varchar(30) not null primary key,
-> value int) engine=ndb;
090617 13:21:36 [Note] NDB Binlog: CREATE TABLE Event: REPL$test/assets
090617 13:21:36 [Note] NDB Binlog: logging ./test/assets (UPDATED,USE_WRITE)
090617 13:21:37 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$test/assets
090617 13:21:37 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$test/assets
090617 13:21:37 [Note] NDB Binlog: logging ./test/assets (UPDATED,USE_WRITE)
090617 13:21:37 [Note] NDB Binlog: logging ./test/assets (UPDATED,USE_WRITE)
Query OK, 0 rows affected (0.99 sec)
mysql> insert into assets values ('Car','1900');
Query OK, 1 row affected (0.03 sec)
mysql> select * from assets;
+------+-------+
| name | value |
+------+-------+
| Car  |  1900 |
+------+-------+
1 row in set (0.00 sec)
mysql> quit
Bye

Note that as this table is using the ndb (MySQL Cluster) storage engine, the data is actually held in the data nodes rather than in the SQL node and so we can access the exact same data from either of the other 2 SQL nodes:

[billy@ws1 7_0_6]$ bin/mysql -h localhost -P 3307
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 5
Server version: 5.1.34-ndb-7.0.6-cluster-gpl-log MySQL Cluster Server (GPL)
type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from assets;
+------+-------+
| name | value |
+------+-------+
| Car  |  1900 |
+------+-------+
1 row in set (0.00 sec)
mysql> quit
Bye

Your next steps

This is a very simple, contrived set up – in any sensible deployment, the nodes would be spread across multiple physical hosts in the interests of performance and redundancy (take a look at the new article (Deploying MySQL Cluster over multiple host) to see how to do that). You’d also set several more variables in the configuration files in order to size and tune your Cluster.





43 comments

  1. Gareth Bult says:

    Be interested to hear from other people running this sort of setup .. I run something almost identical (but with two management nodes) and have done for about 18 months. Reliability and performance are terrible and to date I’ve lost all my data twice. [in particular, it seems not to want to deal with power outages gracefully]

    Maybe it’s because I’m on a slightly older version, but given the problems I’ve had and the ones I’ve seen some people having upgrading, I’m pretty much afraid to touch it.

    I’ve also found the default action of using RAM rather than disk rather limiting, and although you can now use disk for some tables, it seems “fiddley”.

    Also (!) some things that work on other tables fail to work on NDB based tables .. although documented this isn’t necessarily all that obvious. For example I was caught out thinking I could just move current stuff to the cluster .. this fell down when I discovered full text indexing isn’t supported (!)

  2. admin says:

    Gareth,

    have you raised the data loss issue with the Cluster forum (http://forums.mysql.com/list.php?25) or the Cluster mailing list (cluster@lists.mysql.com)? While the advice would be to try to set things up such that a single power failure didn’t impact all of the data nodes making up a node group, that isn’t always possible and I wouldn’t expect data to be lost – if you haven’t done so already, raise the issue so that it can be identified whether there’s a bug or if there is something in your configuration that could be changed.

    You make a good point that it’s worth checking the known limitations of MySQL Cluster in the documentation before making the switch. Over time, the list will get shorter but there are things that MySQL currently can’t do that other storage engines can (e.g. foreign keys aren’t supported but you can simulate them using stored procedures).

    • victor kerber says:

      Hi Andrew,
      I am trying to implement the MySQL cluster … but I’m having a lot of difficulties and can barely find material on my doubts.

      I know the topic is not about that, but I would like to help me …

      Installed cluster religiously following:
      http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-install-linux-binary.html

      At the end, I used the Auto-installer to configure and start the cluster so far ok … I performed tests and I could see my data replicated … but when testing the resistance to failure, simulating the desligamendo the physical server where is the date Nod1, that did not work … I can not start the Nod1 again … to try to get the following error:
      [Root @ Nod1 bin] # ./ndbd
      Unable to connect with connect string: nodeid = 0, localhost: 1186
      Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1 failed.
      05/19/2015 18:05:16 [ndbd] ERROR – Could not connect to server management, error ”

      What should I do to fix? Replication still works but I’m just with NOD2 ..

      I appreciate your help.

      • andrew says:

        Is the ndb_mgmd process running on the same machine where you’re trying to start the data node? If not then you you need to explicitly provide its location… ndbmtd --connect-string="other-host:1186".

  3. Phil says:

    Hello Andrew,

    Great article – thanks a lot! I am really looking forward to the article you mentioned redarding the distribution amongst multiple servers.

    Cheers,
    Phil

  4. […] post builds upon the earlier article (Creating a simple Cluster on a single LINUX host) which explained how to install and run a Cluster where all of the nodes run on the same physical […]

  5. […] Following this you can configure and use the software as normal (refer to Creating a simple Cluster on a single LINUX host). […]

  6. […] installed MySQL Cluster  – if that isn’t the case then please first refer to “Creating a simple Cluster on a single LINUX host” or “Deploying MySQL Cluster over multiple […]

  7. […] installed MySQL Cluster  – if that isn’t the case then please first refer to “Creating a simple Cluster on a single LINUX host” or “Deploying MySQL Cluster over multiple […]

  8. […] on ClusterJ rather than on running MySQL Cluster; if you are new to MySQL Cluster then refer to running a simple Cluster before trying this […]

  9. […] on ClusterJPA rather than on running MySQL Cluster; if you are new to MySQL Cluster then refer to Running a simple Cluster before trying these […]

  10. Steve says:

    Hi.. How to know where i can find the configuration for localhost:1186 ? And what for we used this port ? Can you help me to show me, where i can found the configuration ? Because i try to connect to “ndb_mgm”, when i use “show” it shown “Unable to connect with connect string: nodeid=0, localhost:1186”. I try to look for that port with “netstat”, but i don’t find that port is listen.

    • admin says:

      Hi Steve,

      1186 is the default port that the MySQL Cluster management node uses (can be override it in config.ini). When you run ndb_mgmd, it will listen to that port.

      Regards, Andrew.

  11. Daniel Cabrera says:

    Great work and thanks a lot for this guide.

    I´ve followed the instructions, and found some problems on ubuntu 10.04 and MySqlCluster 7.0.13 .

    I´d like to share this to people who migth find the same problems on ubuntu.

    First, the base_dir must be owned by mysql user( “mysql” in my system), else scripts/mysql_install_db fails to install the databases.
    It took me a while to discover this, but scripts/mysql_install_db runs flawlessly after running

    shell>chown -R mysql “extracted folder” ( in this guide /home/billy/mysql/7_0_6 )

    after creating the data folders

    Then, in the my.*.conf files, you must alter three lines :

    1.-> “log-bin” should read “log-bin=auth-bin” (or whatever log type you want ) to get rid of this warning when running mysqld

    ” No argument was provided to –log-bin, and –log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use ‘–log-bin=auth-bin’ to avoid this problem. ”

    2.-> You must add this line “user=mysql” to run bin/mysql without errors and security warnings

    3.-> Also,you should include “socket=/tmp/my.*.sock”
    were * is the nomber of the config file name(you could use whatever file name you want, they just have to be different for each config file) to connect to servers using bin/mysql.

    The command should be :

    shell>bin/mysql -h localhost -P 3306 –socket=/tmp/my.1.sock

    to avoid this error :

    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

    So, finally the conf/my.1.conf file should look like this :

    [mysqld]
    user=mysql
    ndb-nodeid=4
    ndbcluster
    datadir=”basedir”/data/data1
    basedir=”basedir”
    port=3306
    server-id=1
    log-bin=auth-bin
    socket=/tmp/my.1.sock

    Hope this helps to get this demo install running on Lucid Lynx

    Thanks again for your guide.

  12. Kamal says:

    Hi, I have followed your instruction to setup the mysql cluster on cloud VM with CentOS hosted on it. First time all went fine, i was able to see the whole cluster connected. after that I shutdown the cluster with ndb_mgmd shutdown command. Then after some time I tried to re-start it, but there is an error saying
    2015-03-23 13:05:57 [MgmtSrvr] INFO — The default config directory ‘/usr/local/mysql/mysql-cluster’ does not exist. Trying to create it…
    Failed to create directory ‘/usr/local/mysql/mysql-cluster’, error: 2
    2015-03-23 13:05:57 [MgmtSrvr] ERROR — Could not create directory ‘/usr/local/mysql/mysql-cluster’. Either create it manually or specify a different directory with –configdir=

    But when i create the directory it say, unable to identify which node need to start.

    What to do… i searched on the net, tried all the possible solution I could found. Can you please help me out. thanks.

  13. Manoj says:

    I am trying this:

    bin/mysqld –user=root –defaults-file=conf/my.1.conf&

    I am getting following error.

    2015-04-24 07:36:07 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2015-04-24 07:36:07 0 [Warning] Ignoring user change to ‘root’ because the user was set to ‘mysql’ earlier on the command line

    2015-04-24 07:36:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-04-24 07:36:07 0 [Note] bin/mysqld (mysqld 5.6.24-ndb-7.3.9-cluster-gpl-log) starting as process 10591 …
    2015-04-24 07:36:07 10591 [ERROR] Can’t read from messagefile ‘/usr/share/mysql/english/errmsg.sys’

    • andrew says:

      When you setup the system tables, did you provide your config file…
      ./scripts/mysql_install_db --defaults-file=my.cnf

      Andrew.

      • Manoj says:

        Andrew, yes I have provided it.

        • andrew says:

          Try running mysql_instal_db with the --nodefaults option.

          • Manoj says:

            Hi, I have did what you suggested, but not working. I can see the following error in error.log file:

            2015-04-24 08:57:21 15545 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
            2015-04-24 08:57:21 15545 [Note] Plugin ‘FEDERATED’ is disabled.
            2015-04-24 08:57:21 15545 [Note] Plugin ‘ndbcluster’ is disabled.
            2015-04-24 08:57:21 15545 [Note] InnoDB: Using atomics to ref count buffer pool pages
            2015-04-24 08:57:21 15545 [Note] InnoDB: The InnoDB memory heap is disabled
            2015-04-24 08:57:21 15545 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
            2015-04-24 08:57:21 15545 [Note] InnoDB: Memory barrier is not used
            2015-04-24 08:57:21 15545 [Note] InnoDB: Compressed tables use zlib 1.2.3
            2015-04-24 08:57:21 15545 [Note] InnoDB: Using Linux native AIO
            2015-04-24 08:57:21 15545 [Note] InnoDB: Using CPU crc32 instructions
            2015-04-24 08:57:21 15545 [Note] InnoDB: Initializing buffer pool, size = 128.0M
            2015-04-24 08:57:21 15545 [Note] InnoDB: Completed initialization of buffer pool
            2015-04-24 08:57:21 15545 [Note] InnoDB: Highest supported file format is Barracuda.
            2015-04-24 08:57:22 15545 [Note] InnoDB: 128 rollback segment(s) are active.
            2015-04-24 08:57:22 15545 [Note] InnoDB: Waiting for purge to start
            2015-04-24 08:57:22 15545 [Note] InnoDB: 5.6.24 started; log sequence number 298796228394
            2015-04-24 08:57:22 15545 [ERROR] bin/mysqld: unknown variable ‘defaults-file=conf/my.3.conf’
            2015-04-24 08:57:22 15545 [ERROR] Aborting

          • andrew says:

            Are you sure that you’re using --defaults... rather than -defaults...? It has to be --

            Andrew.

          • Manoj says:

            Andrew, this is what I am trying.

            bin/mysqld –user=root –defaults-file=/home/linux/mysql73/conf/my.3.conf&

          • Manoj says:

            Andrew, I am using the correct syntax, may be my copy paste in the comment is wrong, but this is what exactly I am trying.

            bin/mysqld –user=root –defaults-file=/home/linux/mysql73/conf/my.3.conf&

          • Manoj says:

            Hey Andrew, I got it fixed, actually –defaults-file=/home/linux/mysql73/conf/my.3.conf should be my first option and –user=root should be my second option. I have made it reverse. Now the conrfiguraton shows in this way. Please tell me if it is correct.

            root@linux03:~/mysql73# bin/ndb_mgm
            — NDB Cluster — Management Client —
            ndb_mgm> show
            Connected to Management Server at: localhost:1186
            Cluster Configuration
            ———————
            [ndbd(NDB)] 2 node(s)
            id=2 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9, Nodegroup: 0, *)
            id=3 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9, Nodegroup: 0)

            [ndb_mgmd(MGM)] 1 node(s)
            id=1 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9)

            [mysqld(API)] 3 node(s)
            id=4 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9)
            id=5 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9)
            id=6 @127.0.0.1 (mysql-5.6.24 ndb-7.3.9)

          • andrew says:

            All looks good 🙂

            Any reason why you’re using MySQL Cluster 7.3 rather than 7.4?

          • Manoj says:

            Andrew, sorry to post again, now I face a different kind of error:

            root@linux03:~/mysql73# bin/mysql -h localhost -P 3306
            ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)

            Can you please help on this.

          • andrew says:

            Try replacing localhost with 127.0.0.1. Another little MySQL quirk!

          • Manoj says:

            No reason, I just went to the downloaded page and it 7.3 was the latest one.

            You mean to say I need to change configuration in config.ini file? or in my.cnf?

          • Manoj says:

            Hey Andrew, It worked great. Appreciate you patience in answering.

            You dont have to reply to all of us, but still you are doing. Totally appreciate your work.

            Looking forward for a tutorial on how to put one data node in a different machine by make necessary changes in the same setup.

  14. Manoj says:

    Hi, I have did what you suggested, but not working. I can see the following error in error.log file:

    2015-04-24 08:57:21 15545 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
    2015-04-24 08:57:21 15545 [Note] Plugin ‘FEDERATED’ is disabled.
    2015-04-24 08:57:21 15545 [Note] Plugin ‘ndbcluster’ is disabled.
    2015-04-24 08:57:21 15545 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-04-24 08:57:21 15545 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-04-24 08:57:21 15545 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-04-24 08:57:21 15545 [Note] InnoDB: Memory barrier is not used
    2015-04-24 08:57:21 15545 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2015-04-24 08:57:21 15545 [Note] InnoDB: Using Linux native AIO
    2015-04-24 08:57:21 15545 [Note] InnoDB: Using CPU crc32 instructions
    2015-04-24 08:57:21 15545 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2015-04-24 08:57:21 15545 [Note] InnoDB: Completed initialization of buffer pool
    2015-04-24 08:57:21 15545 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-04-24 08:57:22 15545 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-04-24 08:57:22 15545 [Note] InnoDB: Waiting for purge to start
    2015-04-24 08:57:22 15545 [Note] InnoDB: 5.6.24 started; log sequence number 298796228394
    2015-04-24 08:57:22 15545 [ERROR] bin/mysqld: unknown variable ‘defaults-file=conf/my.3.conf’
    2015-04-24 08:57:22 15545 [ERROR] Aborting

  15. Ashish Batler says:

    i did this
    bin/mysqld –defaults-file=conf/my.1.conf&
    did not work

    then i added –user=root and still it did not work

    root@ashishbatler:/home/ashu/mysql/7_0_6# bin/ndb_mgm
    — NDB Cluster — Management Client —
    ndb_mgm> show
    Connected to Management Server at: localhost:1186
    Cluster Configuration
    ———————
    [ndbd(NDB)] 2 node(s)
    id=2 @127.0.0.1 (mysql-5.1.67 ndb-7.0.37, Nodegroup: 0, Master)
    id=3 @127.0.0.1 (mysql-5.1.67 ndb-7.0.37, Nodegroup: 0)

    [ndb_mgmd(MGM)] 1 node(s)
    id=1 @127.0.0.1 (mysql-5.1.67 ndb-7.0.37)

    [mysqld(API)] 3 node(s)
    id=4 (not connected, accepting connect from localhost)
    id=5 (not connected, accepting connect from localhost)
    id=6 (not connected, accepting connect from localhost)

    ndb_mgm>

    • andrew says:

      Were you given an error message when the mysqld failed to start? Note that the --user=root option is for when you run the mysql client. Your command shows that your running as your machine’s root – the mysqld is not meant to be run by root and so that might be why it’s failing.

      Andrew.

  16. Manoj says:

    Hi Andrew,

    I have created database in one mysqld and trying to see it in others, it worked fine.
    But when I created few tables in that database and tried to see in the others, it is not working, actually tables what I created are more, will take time to reflect on other mysqld’s ??

    • Manoj says:

      Hi Andrew, I got the answer from my query, thanx.

      But there is another issue, I am not able to access sql nodes from outside, I have executed following command in mysql console, it worked fine.
      grant all on *.* to ‘%’@’%’ identified by ‘password’ with grant option

      But, when I went to remote machine and does this, it is not working. This is the output:

      manoj@manoj-Vostro-3546:~$ mysql -h 10.0.0.203 -P 3308
      ERROR 1045 (28000): Access denied for user ‘manoj’@’manoj-Vostro-3546.local’ (using password: NO)

      Can you please help on this.

  17. Manoj says:

    Hi Andrew, I am trying to create some tables, but after some time it is showing following error, any idea how to handle this.

    2015-06-02 19:12:18 3888 [ERROR] bin/mysqld: The table ‘assets’ is full
    ERROR 1114 (HY000): The table ‘assets’ is full

    • Manoj says:

      Hi Andrew, this is the result of ALL REPORT MEMORY

      Node 2: Data usage is 0%(45 32K pages of total 98048)
      Node 2: Index usage is 0%(408 8K pages of total 392224)
      Node 3: Data usage is 0%(45 32K pages of total 98048)
      Node 3: Index usage is 0%(408 8K pages of total 392224)

      it shows 0%, but still I am getting table full error, thanks in advance.

    • andrew says:

      Sorry for the delay – I’m not able to check at this point but it’s worth raising the question on the MySQL Cluster forum.

  18. dejau says:

    Is there no more mysql auto installer gui in linux? just noticed the tutorial is only in windows though. Or I am just mistaken, it must be a commercial license. Please advise

Leave a Reply