Install Mysql cluster on Fedora box


Each MySQL Cluster host computer running an SQL node must have installed on it a MySQL. For management nodes and data nodes,
it is not necessary to install the MySQL server binary,
but management nodes require the management server daemon (ndb_mgmd) and data nodes require the data node daemon (ndbd).

It is also a good idea to install the management client (ndb_mgm) on the management server host.
This section covers the steps necessary to install the correct binaries for each type of Cluster node.

Important Note:
If you have mysql installed already than remove that from computer using following command
[root@localhost purab]# yum remove mysql mysql-server mysql-libs mysql-common

Open http://dev.mysql.com/downloads/
click on * MySQL Cluster url:
http://dev.mysql.com/downloads/select.php?id=14
Scoll down,
Under “Current Realeases” section
You will see the following text;
MySQL Cluster 7.0.8a GA
Select the Red Hat Enterprise Linux here and download following packages.

Select Operating System: Red Hat Enterprise Linux
As per linux edition(4 and 5) and computer and Os comptable(64bit or 32bit download the RPMs
I am using the Fedora 11 as OS and 32bit Intel machine.
I used or downloaded following RPM files from above URL:
MySQL-Cluster-gpl-debuginfo-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-embedded-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-7.0.8a-0.rhel5.src.rpm
MySQL-Cluster-gpl-7.0.8a-0.sles11.src.rpm
MySQL-Cluster-gpl-devel-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-tools-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-test-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-extra-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-storage-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-shared-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-management-7.0.8a-0.rhel5.i386.rpm

SQL node installation — RPM files. On each machine to be used for hosting a cluster SQL node, install the Server RPM by executing the following command as the system root user, replacing the name shown for the RPM as necessary to match the name of the RPM downloaded from the MySQL web site:

How to repeat:
Make sure you have nothing in /var/lib/mysql and /var/lock/subsys/mysql.
The do :
rpm -i MySQL-client-5.1.25-0.glibc23.x86_64.rpm MySQL-server-5.1.25-0.glibc23.x86_64.rpm

[root@localhost MysqlClusterSoft]# rpm -iv MySQL-Cluster-gpl-*

Forcely install the above rpms again, for that use following command.
[root@localhost MysqlClusterSoft]# rpm -ivh –force MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm

Following command you can use for uninstall the Mysql cluster.
[root@localhost MysqlClusterSoft]# rpm -e -F MySQL-Cluster-gpl-*

[root@localhost MysqlClusterSoft]# yum install mysql mysql-server

[root@localhost MysqlClusterSoft]# rpm -Uhv MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm
Preparing… ########################################### [100%]
1:MySQL-Cluster-gpl-serve########################################### [100%]
091113 17:05:13 [Warning] Forcing shutdown of 3 plugins
091113 17:05:13 [Warning] Forcing shutdown of 3 plugins

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h localhost.localdomain password ‘new-password’

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/

[root@localhost MysqlClusterSoft]#

[root@localhost MysqlClusterSoft]# rpm -Uhv MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386.rpm
Preparing… ########################################### [100%]
package MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386 is already installed

After all installtion Please reboot the machine. and Run the nbdb server and load the sample data.
Use following article…
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-multi-load-data-queries.html

Advertisements
This entry was posted in PHP and tagged , , by Purab Kharat. Bookmark the permalink.

About Purab Kharat

I am WordPress and Drupal Architect. I worked on many technologies like Ruby on Rails, Flex, PHP etc... I am Purab Kharat from India, Pune. I love to play chess and listen music and read books. I work in SY Smartsourcing Global Pvt Ltd in Princeton, NJ, USA. Now I am living at Plainsboro, 164 Hampshire Drive, Princeton Meadows, NJ. I have more then Ten years experience in Web Application Development (Specially in Php 5.0, Ruby on Rails, Mysql 5.0, RIA, Wordpress, Drupal, Joomla, Ecommerce)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s