Wednesday, 30 April 2014

Quick Installation of MySQL Cluster NDB 7.3 - PART 2

Recently I've started to explain how to install quickly the new MySQL Cluster NDB 7.3 and now I'm ready to continue.

Let's start, shall we ?


STEP 2 : On every SQL Nodes execute the following command as root:

[root@MysqlVm04ClusterData1 mysql]# cd /usr/local/mysql
[root@MysqlVm04ClusterData1 mysql]# scripts/mysql_install_db --user=mysql


NB: If we want to change the root password of MySQL database or remove the anonymous user we have to execute the following command :

$BASE_DIR/bin/mysql_secure_installation

The "mysql_install_db" command is necessary to create the system databases on the SQL Nodes. Afterwards we can modify the .bash_profile file of mysql user adding the following row :


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


STEP 3: On all Data Nodes we have only to be sure of adding the binary directory of MySQL in the environment variable PATH
 
export 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 continued ....


See you in my next Blog.

Byeee

No comments:

Post a Comment