Quick Installation of MySQL Cluster NDB 7.3 - PART 3

Let's continue with the installation, shall we ?

STEP 3: On every Data Nodes we have only to be sure of adding the binary directory of MySQL in the environment variable PATH :

PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/mysql/bin

To be honest only the ndbd executable file is necessary to start the Data Nodes because I haven't got enough resources on my virtual machine server so I have to share the Data Nodes and SQL Nodes on the same linux server.

On every Management Nodes we have only to apply the same procedure followed before.

Now we are ready to get down the configuration process of the Cluster.

STEP 4 : Configuring the SQL Nodes:

File :  /etc/my.cnf

[mysqld]
# Options for mysqld process:
ndbcluster                      # run NDB storage engine

[mysql_cluster]
# Options for MySQL Cluster processes:
ndb-connectstring=10.5.250.101,10.5.250.102  # location of management server

As you can see, we have only to declare the [mysqld] and [mysql_cluster] section, adding the storage engine NDB and the address of the management nodes.

Be careful ! Once the mysqld daemon is started with the option "ndbcluster" enabled, you can't execute a SQL command like "create table" if the other nodes of the cluster aren't started too.

To be continued ....



See you in my next Blog.

Byeeeeeee