welcome to netwrkspider

Thursday, December 13, 2012

How To: Install Mysql Cluster on ubuntu 12.04/10.04 LTS from source code

#Introduction : 

MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability. MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL ("NDB" stands for Network Database).


#AIM : Installation of Mysql Cluster in Linux Platform ( Ubuntu 12.04/10.04 LTS )

#Infrastructure Details : ( All System having ubuntu 12.04 )

1 ) machine01 : Management( IP : 192.168.28.28 )
2 ) machine02 : Data Node/Sql Node ( IP : 192.168.28.2 )
3 ) machine03 : Data Node/Sql Node ( IP : 192.168.28.3 )
4 ) machine04 : Data Node/Sql Node ( IP : 192.168.28.4 )

#Get the Software 

Make Sure you select the correct platform.

 http://www.mysql.com/downloads/cluster/

here i am going to install mysql cluster from source code & i have downloaded the package mysql-cluster-gpl-7.2.9.tar.gz ( Note : Select Source code & download the Generic Linux (Architecture Independent), Compressed TAR Archive )

########################################################################

#Installation of Data Node & sql Node on machine02, machine03 and machine04:

#Step 1 : Installing Mysql Cluster on machine01:

Login with root :

#Installing dependencies for Mysql Server

root@machine02: ~#apt-get install bison libncurses5-dev libtool g++ gcc make cmake; 

#Extracting mysql

root@machine02: ~# tar xvfz mysql-cluster-gpl-7.2.8.tar.gz -C /usr/local/src
root@machine02: ~# chown -R root.root /usr/local/src//mysql-cluster-gpl-7.2.8/
root@machine02: ~# cd /usr/local/src//mysql-cluster-gpl-7.2.8

#Configuring  Mysql Cluster 

root@machine02:/usr/local/src/mysql-cluster-gpl-7.2.8# cmake .

#Installing Mysql clCluster

root@machine02:/usr/local/src/mysql-cluster-gpl-7.2.8# make clean install 

# Adding mysql user and group

root@machine02:/usr/local/src/mysql-cluster-gpl-7.2.8# groupadd mysql; useradd -g mysql mysql

root@machine02:/usr/local/src/mysql-cluster-gpl-7.2.8# cd /usr/local/mysql 
root@machine02:/usr/local/mysql# cp support-files/my-medium.cnf /etc/my.cnf
root@machine02:/usr/local/mysql# chown -R mysql . ; chgrp -R mysql .

#Dumping essential data in mysql 

root@machine02:/usr/local/mysql# ./scripts/mysql_install_db --user=mysql
root@machine02:/usr/local/mysql# chown -R root . ; chown -R mysql data

#Putting mysql executables in PATH

root@machine02:/usr/local/mysql# cd /usr/local/mysql/bin/ 
root@machine02:/usr/local/mysql/bin/for file in *;  do rm /usr/bin/$file;  ln -s /usr/local/mysql/bin/$file /usr/bin/$file;  done;

#Starting Mysql..

root@machine02:/usr/local/mysql/bin/# ./mysqld_safe --user=mysql& 1>/dev/null

#Securing Mysql Cluster installation 

root@machine02:/usr/local/mysql/bin/# ./mysql_secure_installation

Note : After execution above cmd do the on screen instruction set root password, 
remove anonymous user, etc. [ i have set "y" for every instruction ]   

#Now log into mysql database
root@machine02:/usr/local/mysql/bin/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.27-ndb-7.2.8-log Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

#Step 2 : Do  the same above operation on machine03 & machine04  


#########################################################################


#Installation of Management node on machine01

Login with root :

#Installing dependencies for Mysql Server

root@machine01: ~#apt-get install bison libncurses5-dev libtool g++ gcc make cmake; 

#Extracting mysql

root@machine01: ~# tar xvfz mysql-cluster-gpl-7.2.8.tar.gz -C /usr/local/src
root@machine01: ~# chown -R root.root /usr/local/src//mysql-cluster-gpl-7.2.8/
root@machine01: ~# cd /usr/local/src//mysql-cluster-gpl-7.2.8

#Configuring  Mysql Cluster 

root@machine01:/usr/local/src/mysql-cluster-gpl-7.2.8# cmake .

#Installing Mysql cluster

root@machine01:/usr/local/src/mysql-cluster-gpl-7.2.8# make clean install 

# Adding mysql user and group

root@machine01:/usr/local/src/mysql-cluster-gpl-7.2.8# groupadd mysql; useradd -g mysql mysql

root@machine01:/usr/local/src/mysql-cluster-gpl-7.2.8# cd /usr/local/mysql 
root@machine01:/usr/local/mysql# cp support-files/my-medium.cnf /etc/my.cnf
root@machine01:/usr/local/mysql# chown -R mysql . ; chgrp -R mysql .

#Dumping essential data in mysql 

root@machine01:/usr/local/mysql# ./scripts/mysql_install_db --user=mysql
root@machine01:/usr/local/mysql# chown -R root . ; chown -R mysql data

#Putting mysql executables in PATH

root@machine01:/usr/local/mysql# cd /usr/local/mysql/bin/ 
root@machine01:/usr/local/mysql/bin/for file in *; do rm /usr/bin/$file; ln -s /usr/local/mysql/bin/$file /usr/bin/$file; done;

#Starting Mysql..

root@machine01:/usr/local/mysql/bin/# ./mysqld_safe --user=mysql

#Securing Mysql Cluster installation 

root@machine01:/usr/local/mysql/bin/# ./mysql_secure_installation

Note : After execution above cmd do the on screen instruction set root password, 
remove anonymous user, etc. [ i have set "y" for every instruction ]   

#Now log into mysql database
root@machine02:/usr/local/mysql/bin/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.27-ndb-7.2.8-log Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Note : Installation of the management node does not require the mysqld binary.
but i have installed on machine01.
--------------------------------------------------------------------------------------------------------------------------------

#Configuration of management node on machine01.

root@machine01:~# mkdir /var/lib/mysql-cluster
root@machine01:~# cd  /var/lib/mysql-cluster
root@machine01:/var/lib/mysql-cluster# vim config.ini
 
 for our setup, The config.ini file should read as follows: 
---------------------------------------------------------------------------------------------------------------------------------
# Example Ndbcluster storage engine config file.
#
[ndbd default]
NoOfReplicas= 3
MaxNoOfConcurrentOperations= 10000
DataMemory= 2048M
IndexMemory= 1024M
#TimeBetweenWatchDogCheck= 10000
DataDir= /usr/local/mysql
MaxNoOfAttributes=5000
MaxNoOfOrderedIndexes= 500
#ServerPort=2200
#FragmentLogFileSize=1073741824
[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
HostName=
192.168.28.28
[ndbd]
HostName=192.168.28.2
[ndbd]
HostName=192.168.28.3
[ndbd]
HostName=192.168.28.4

[mysqld]
HostName=192.168.28.2
[mysqld]
HostName=192.168.28.3
[mysqld]
HostName=192.168.28.4

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
#PortNumber= 63132


 

--------------------------------------------------------------------------------------------------------------------------------- 



#Configuration of Data/SQL Nodes on machine02, machine02 and machine03  

 For each data node and SQL node in our setup, my.cnf should look like this:

-------------------------------------------------------------------------------------------------------------------------------
 # Example MySQL config file for medium systems.


# The following options will be passed to all MySQL clients
[client]
#password    = your_password
port        = 3306
socket        = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port        = 3306
socket        = /tmp/mysql.sock

# Options for to access mysql cluster datanode
ndbcluster                                 # run NDB storage engine
ndb-connectstring=192.168.28.28           # location of management server


skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

server-id    = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysql_cluster]
# Options for ndbd process:
ndb-connectstring=192.168.28.28

-------------------------------------------------------------------------------------------------------------------------------

#Starting the MySQL Cluster

1 ) On the management host(machine01), issue the following command from the system shell to start the management node process

-------------------------------------------------------------------------------------------------------------------------------

root@machine01:~# /usr/local/mysql/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster --initial

------------------------------------------------------------------------------------------------------------------------------- 

2 ) On each of the Data/SQL node hosts, run these commands to start the ndbd and mysql server process

--------------------------------------------------------------------------------------------------------------------------------
 root@machine02:~# /usr/local/mysql/bin/ndbd  --initial
  
root@machine02:~# /usr/local/mysql/support-files/mysql.server start
 
--------------------------------------------------------------------------------------------------------------------------------

#Now login into machine01 (Management Node )
--------------------------------------------------------------------------------------------------------------------------------

root@machine01:~#ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]    3 node(s)
id=2    @192.168.28.2 (mysql-5.5.27 ndb-7.2.8, Nodegroup: 0, Master)

id=3    @192.168.28.3 (mysql-5.5.27 ndb-7.2.8, Nodegroup: 0)
id=4    @192.168.28.4 (mysql-5.5.27 ndb-7.2.8, Nodegroup: 0)
 

[ndb_mgmd(MGM)]    1 node(s)
id=1    @192.168.28.28  (mysql-5.5.27 ndb-7.2.8)

[mysqld(API)]    3 node(s)
id=5
@192.168.28.2 (mysql-5.5.27 ndb-7.2.8)
id=6
@192.168.28.3  (mysql-5.5.27 ndb-7.2.8)
id=7 @192.168.28.4  (mysql-5.5.27 ndb-7.2.8) 
--------------------------------------------------------------------------------------------------------------------------------

#######################################################################

Testing the mysql Cluster Setup

####################################################################### 

On either server machine01 , machine02 and machine03 enter the following commands:
-----------------------------------------------------------------------------------------------------------------------------
root@machine02:~#mysql -uroot -p
Enter password:

mysqlcreate database testdb;
mysql > use test;
mysql > CREATE TABLE cluster_test (i INT) ENGINE=NDBCLUSTER;
mysql > INSERT INTO cluster_test (i) VALUES (1);
mysql > SELECT * FROM cluster_test;
----------------------------------------------------------------------------------------------------------------------------

If this works, now go to the other server and run the same SELECT and see what you will get. Insert from that host and go back to previous host and see if it works. If it works then congratulations! 

Enjoy :) 


###################################################################################
Troubleshoot Guide
###################################################################################
 
 





14 comments:

Unknown said...

Thank you abhishek

Unknown said...

thank you abhishek

Anonymous said...

Exceuse me when I run cmake .

these message was output

I already check for my java environment path

in the /etc/profile


export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$PATH:$CATALINA_HOME/bin



-- Could NOT find Java (missing: Java_JAR_EXECUTABLE Java_JAVAC_EXECUTABLE Java_JAVAH_EXECUTABLE Java_JAVADOC_EXECUTABLE) (found version "1.6.0.24")
-- Could NOT find JNI (missing: JAVA_INCLUDE_PATH JAVA_INCLUDE_PATH2 JAVA_AWT_INCLUDE_PATH)

Matthew Bone said...

do this before you do the cmake command:

sudo apt-get remove openjdk-7-jdk
sudo apt-get remove openjdk-6-jdk
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

replace the cmake . command from the tutorial with the following command:

cmake -DJAVA_INCLUDE_PATH=/usr/lib/jvm/java-7-oracle/include \ -DJAVA_INCLUDE_PATH2=/usr/lib/jvm/java-7-oracle/include/linux .

Matthew Bone said...

oh actually do this command

apt-get install python-software-properties

before you do add-apt-repository

Anonymous said...

excuse me, when I run cmake, a message displays,
root@olophon-HP-ProBook-4420s:/usr/local/src/mysql-cluster-gpl-7.2.12-linux2.6-i686# cmake .
CMake Error: The source directory "/usr/local/src/mysql-cluster-gpl-7.2.12-linux2.6-i686" does not appear to contain CMakeLists.txt.

Can you give a solution ?
Thx..

Anonymous said...

Excuse me, when i run cmake .,a message displays,
root@olophon-HP-ProBook-4420s:/usr/local/src/mysql-cluster-gpl-7.2.12-linux2.6-i686# cmake .
CMake Error: The source directory "/usr/local/src/mysql-cluster-gpl-7.2.12-linux2.6-i686" does not appear to contain CMakeLists.txt.
Specify --help for usage, or press the help button on the CMake GUI.

Can you give a solution?
Thx

Anonymous said...

Hi

I have the same problem when I run cmake command

CMake Error: The source directory does not appear to contain CMakeLists.txt.
Specify --help for usage, or press the help button on the CMake GUI

Any ideas?

Anonymous said...

Pls try to download source code tar files from mysql site.

Unknown said...

Thanks For the Guide, but when I try cmake. in the mysql-cluster folder it shows me the foolowing error:CMake Error at CMakeLists.txt:24 (INCLUDE):
include could not find load file:

win/configure.data
I appreciate your soon reply.
Thanks
Amir

Unknown said...

Thanks For the Guide, but when I try cmake. in the mysql-cluster folder it shows me the foolowing error:CMake Error at CMakeLists.txt:24 (INCLUDE):
include could not find load file:

win/configure.data
I appreciate your soon reply.
Thanks
Amir

Unknown said...

Thanks for the instruction. When I found that I was so happy. I guessed I am done. but after 'cmake .' in the mysql-cluster directory I get error:
CMake Error at CMakeLists.txt:24 (INCLUDE):
include could not find load file:

win/configure.data
I appreciate your soon reply
Thanks
Amir

Unknown said...

Can u teach me to how to hack clash of clans please

Unknown said...

Can u teach me to how to hack clash of clans please