Adding Proxy Server to MySQL Cluster

It’s not uncommon that one of two Application Servers breaks and you need to manually edit config on the Application Client to point to the other Application Server.

To enable automatic failover switching we will setup a Proxy Server. In later tests we will examine how Proxy Server affects the delay.

Start out by downloading a MySQL Proxy.

// Install needed libraries

mgm1: #apt-get install libevent-dev pkg-config  liblua5.1-dev libglib2.0-0 libglib2.0-dev libmysqlclient-dev

(more…)

Adding two ndb nodes to MySQL Cluster

In the end we’ll have:

• Two – Management servers (mgm1, mgm2)
• Two – Application servers (app1, app2)
• Four – NDB servers (ndb1, ndb2), (ndb3, ndb4)

(more…)

Adding Management Server to MySQL Cluster

// Preparing the server
// Append to /etc/hosts on every machine

192.168.1.108 mgm2   # second Management Server

(more…)

Adding Application Server to MySQL Cluster

// Preparing the server
// Append to /etc/hosts on every machine

192.168.1.109 app2   # second Application Server

// Login to app2 server and extract files (see previous post)

app2: # tar xzf mysql.tgz -C /usr/local/mysql

(more…)

Configuring MySQL Cluster on 4 Machines

To start we will have the following machines:

• One – Management server (mgm1)
• One – Application server (app1)
• Two – NDB servers (ndb1, ndb2)

// Copy mysql.tgz to each machine (see previous post)
(more…)