Installing The Galera-Iworx Cluster - Page 5
Further we have to configure some status info inside the
<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>
Further we have to add the slave nodes to Interworx for loadbalancing:
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.
We start with the master node:
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
Then we repeat the following steps for all slave nodes
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;
If ok, we go on with the GUI installer:
chmod +x 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.