Quick Installation of MySQL Cluster NDB 7.3 - PART 4

Let's continue with the configuration, shall we ?

STEP 5 :  Configuring the Management node.

We have to create a directory like this : /home/mysql/mysqlCluster and the following config.ini in both the Management Nodes.

SECTION : [ndbd default] : Options affecting ndbd processes on all data nodes:
NoOfReplicas=2    # Number of replicas
DataMemory=80M    # How much memory to allocate for data storage
IndexMemory=18M   # How much memory to allocate for index storage

In this section we can config the option of the Data Nodes, for example we can decide the amount of memory for data and index storage.

Be careful ! These options are going to affect both Data Nodes.

SECTION : [tcp default] :  # TCP/IP options:
portnumber=2202  > Easy to understand !       

SECTION : [ndb_mgmd] : Management process options:
hostname=10.5.250.101           # Hostname or IP address of MGM node
datadir=/home/mysql/mysqlCluster  # Directory for MGM node log files

SECTION : [ndb_mgmd] :  Management process options:
hostname=10.5.250.102           # Hostname or IP address of MGM node
datadir=/home/mysql/mysqlCluster  # Directory for MGM node log files

In these sections we have to declare the IP address of both Management Nodes but according to the manual each Node has to be specified in a different section.

SECTION :  [ndbd] : Options for data node "A" :
hostname=10.5.250.103                   # Hostname or IP address
datadir=/home/mysql/mysqlClusterData    # Directory for this data node's data files

This section refers only to one Data Node, that we'll refer to it as Node A and in which we can config the hostname and data dir.

SECTION : [ndbd] :  Options for data node "B" :
hostname=10.5.250.104                   # Hostname or IP address
datadir=/home/mysql/mysqlClusterData    # Directory for this data node's data files

This section has the same meaning of the previous section.

SECTION :  [mysqld] :  SQL node "A" options:
hostname=10.5.250.103      # Hostname or IP address

This section refers only to one SQL Nodes, that we'll call it as SQL Node "A" and in which we can config the hostname and data dir.


SECTION : [mysqld] : # SQL node "B" options :
hostname=10.5.250.104           # Hostname or IP address 

This section has the same meaning as the previous section.

Now we are ready to start the MySQL Cluster but for today that's all.....

See you in my next blog.

Byeeeeee