MySQL Cluster part 3: Installing SQL Node in Ubuntu Server v.12.04

Bromokun

We are going to install the last piece of the first half of this cluster environment now, which is: an SQL node.

In this learning, I deploy both: SQL and NDB, in a single instance of VM.
So instead of creating a new VM, I’m using the same VM where I deployed an NDB node we created before.

Inside our my.cnf file, which we created on the 7th step  in our previous tutorial, contains a code block like below.

This particular code block, is actually a minimum sets, for creating an SQL node.

So, what we need to do next are:

A. Prerequisites:

  1. Keep the Cluster Manager service ON
  2. Keep the NDB service ON

B. Steps:

1. Creates a new user, called “mysql

2. Download and install libaio package from the internet

3. After libaio package fully installed, executes the script for installing the initial MySQL…

View original post 164 more words

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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