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
Comments
3 comments
32bit ami-973b06e3
wrong browser windows should be part of:
http://support.severalnines.com/entries/20675667-installing-mysql-cluster-on-two-amazon-ec2-instances-fails-because-ndb-mgmd-can-t-be-started?page=1#post_20663621
Thanks for the upgrade info! ClusterControl is crucial for database management. Anyone having issues, definitely follow Johan's link. Feels like simplifying database upgrades is almost as addictive as discovering new elements in Infinite Craft. Is there a changelog detailing specific improvements in 1.1.24 besides what's in the guide? That would be helpful.
Please sign in to leave a comment.