Installing The Galera-Iworx Cluster - Page 5

Further we have to configure some status info inside the

nano /etc/httpd/conf/httpd.conf

ExtendedStatus On

<Location /server-status>
    SetHandler  server-status
    Order  deny,allow
    Deny from all
    Allow from
  <Location /server-info>
    SetHandler  server-info
    Order  deny,allow
    Deny from all
    Allow from


Configuring Interworx

Further we have to add the slave nodes to Interworx for loadbalancing:

Configure loadbalancer:

We have to reinstall packages that where uninstalled :

yum install -y phpMyAdmin xcache-admin mut


Reverse Proxy for HAProxy

We have to configure a (reverse)proxy inside the apache config so we can connect to the page like

echo "ProxyPass /haproxy http://localhost:9600" >> /etc/httpd/conf/httpd.conf
echo "ProxyPassReverse /haproxy http://localhost:9600" >> /etc/httpd/conf/httpd.conf

Restart the required services

service haproxy restart && service httpd restart


Upgrade to ClusterControl 1.2

Since ClusterControl 1.2 is released (7 march) , we should try to upgrade the current installation. Not only since there are some really nice features in it, but also to test if upgrading at all is possible!

When installing a new cluster from scratch you don’t have to do de upgrade steps since it will be 1.2 or higher right after install.


We start with the master node:

cd /usr/local/src
yum -y install php-curl
wget -O cmon-controller-1.2.0-1.x86_64.rpm
wget -O cmon-www-1.2.0-1.noarch.rpm
rpm -Uvh cmon-controller-1.2.0-1.x86_64.rpm
rpm -Uvh cmon-www-1.2.0-1.noarch.rpm
mysql -ucmon -ppw4myCMON < /usr/share/cmon/cmon_db_mods-1.1.36-1.2.0.sql
mysql -ucmon -ppw4myCMON < /usr/share/cmon/cmon_db.sql
mysql -ucmon -ppw4myCMON < /usr/share/cmon/cmon_data.sql
service cmon restart


Slave nodes

Then we repeat the following steps for all slave nodes

cd /usr/local/src
wget -O cmon-agent-1.2.0-1.x86_64.rpm
rpm -Uvh cmon-agent-1.2.0-1.x86_64.rpm
service cmon restart


ClusterControl 1.2 UI

To be sure you could check the master database, if the nodes are on release 1.2:

mysql -ucmon –ppw4myCMON
select hostname, cmon_version from cmon.hosts;

If ok, we go on with the GUI installer:

cd /usr/local/src
chmod +x

To finalize the installation open your web browser and go to this URL, to finalize the installation.

Now click on Install, and you will probably get an ClusterControl UI Installed message:

Click on “Click here to automatically register your cluster now! And you will be redirected to a Registerpage.

Now we are ready to login for the first time:

We copy and paste the URL, from the left top corner into the textbox on right bottom corner, and click register.

And there it is the new ClusterControl 1.2 UI.

Now you're done! Enjoy your Interworx and MySQL Galera Cluster.

Share this page:

0 Comment(s)