Please follow these upgrade instructions in our Administration Guide:

https://severalnines.com/docs/administration.html#upgrading-clustercontrol

[DEPRECATED - DON'T READ BELOW]

This article describes how to upgrade from cmon 1.1.20 to cmon 1.1.24. You are really recommended to upgrade.

cmon 1.1.24 fixes:

• Galera - cleaning of galera_stats_history adding fix to prevent it from blowing up in size.
• Fixing intermittent agent restarts

In the examples below we use Galera, but it is the same steps for MySQL Replication and MySQL Cluster.

RPM install

cd s9s-galera-2.0.0/mysql/repo
wget -O cmon-agent-1.1.24-1.x86_64.rpm http://www.severalnines.com/downloads/cmon/cmon-agent-1.1.24-1.x86_64.rpm 
wget -O cmon-controller-1.1.24-1.x86_64.rpm http://www.severalnines.com/downloads/cmon/cmon-controller-1.1.24-1.x86_64.rpm 
wget -O cmon-www-1.1.24-1.noarch.rpm http://www.severalnines.com/downloads/cmon/cmon-www-1.1.24-1.noarch.rpm 

wget -O cmon_db-1.1.24.sql http://www.severalnines.com/downloads/cmon/cmon_db-1.1.24.sql
wget -O cmon_data-1.1.24.sql http://www.severalnines.com/downloads/cmon/cmon_data-1.1.24.sql

## If you are on v.1.1.20 you need to start at  cmon_db_mods-1.1.20-1.1.21.sql and everything below, 
wget -O cmon_db_mods-1.1.20-1.1.21.sql http://www.severalnines.com/downloads/cmon/cmon_db_mods-1.1.20-1.1.21.sql
wget -O cmon_db_mods-1.1.21-1.1.22.sql http://www.severalnines.com/downloads/cmon/cmon_db_mods-1.1.21-1.1.22.sql

cd s9s-galera-1.0.0/mysql/scripts/install
 
## apply changes in table structures from v1.1.20 to 1.1.22 (no changes beyond that)
mysql -uroot -p cmon < ../../repo/cmon_db_mods-1.1.20-1.1.21.sql
mysql -uroot -p cmon < ../../repo/cmon_db_mods-1.1.21-1.1.22.sql

## Install DB (create new tables - if any, and updates triggers and events) 
mysql -uroot -p cmon < ../../repo/cmon_db-1.1.24.sql
mysql -uroot -p cmon < ../../repo/cmon_data-1.1.24.sql     
   
bash ./install-cmon.sh -c ../../repo/cmon-controller-1.1.24-1.x86_64.rpm \  
 -a ../../repo/cmon-agent-1.1.24-1.x86_64.rpm \
 -w ../../repo/cmon-www-1.1.24-1.noarch.rpm 

If you need to upgrade from an older version please let us know here.

TAR.GZ install

cd s9s-galera-2.0.0/mysql/repo
wget -O cmon-1.1.24-64bit-glibc23-mc70.tar.gz http://www.severalnines.com/downloads/cmon/cmon-1.1.24-64bit-glibc23-mc70.tar.gz

wget -O cmon_db_mods-1.1.20-1.1.21.sql http://www.severalnines.com/downloads/cmon/cmon_db_mods-1.1.20-1.1.21.sql
wget -O cmon_db_mods-1.1.21-1.1.22.sql http://www.severalnines.com/downloads/cmon/cmon_db_mods-1.1.21-1.1.22.sql

## download database + data 
wget -O cmon_db-1.1.24.sql http://www.severalnines.com/downloads/cmon/cmon_db-1.1.24.sql 
wget -O cmon_data-1.1.24.sql http://www.severalnines.com/downloads/cmon/cmon_data-1.1.24.sql  

cd s9s-galera-2.0.0/mysql/scripts/install

#apply changes in table structures between 1.1.20 and 1.1.22 (no changes beyond that)

mysql -uroot -p cmon < ../../repo/cmon_db_mods-1.1.20-1.1.21.sql
mysql -uroot -p cmon < ../../repo/cmon_db_mods-1.1.21-1.1.22.sql
 
## install DB (creates new tables, if any, + updates triggers and events)
mysql -uroot -p cmon < ../../repo/cmon_db-1.1.24.sql
mysql -uroot -p cmon < ../../repo/cmon_data-1.1.24.sql   
 
bash ./install-cmon.sh -f ../../repo/cmon-1.1.24-64bit-glibc23-mc70.tar.gz