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  127.0.0.1
  </Location>
  <Location /server-info>
    SetHandler  server-info
    Order  deny,allow
    Deny from all
    Allow from  127.0.0.1
  </Location>

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 http://192.168.120.1/haproxy

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.

Master

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 http://www.severalnines.com/downloads/cmon/cmon-controller-1.2.0-1.x86_64.rpm
wget -O cmon-www-1.2.0-1.noarch.rpm http://www.severalnines.com/downloads/cmon/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 http://www.severalnines.com/downloads/cmon/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;
exit

If ok, we go on with the GUI installer:

cd /usr/local/src
wget http://severalnines.com/downloads/cmon/setup-cc-ui.sh
chmod +x setup-cc-ui.sh
./setup-cc-ui.sh

To finalize the installation open your web browser and go to this URL, http://192.168.120.1/install 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.