We are using ubuntu 14.04 server edition in our production environment. We installed Zabbix 3.0 compiler edition with the Mysql database 5.5.47 version. I wanted to install the updates for our server except zabbix updates.
I listed updates for my server in which we are having few updates related to Mysql like
Mysql-server-core 5.5
Mysql-mysql-client-5.5 -
mysql-client-core-5.5 -
mysql-common
mysql-server
mysql-server-5.5
Even though this Mysql updates comes under same version, i’m having concerns whether i can update them or not.
But MySql 5.5 is the default for Ubuntu 14.04. For upgrading MySQL you should configure MySQL repository, if you want to update MySQL-5.5 to for ex MySQL-5.7 you should upgrade to MySQL 5.6 first before upgrading to 5.7.
after upgrading mysql-5.5.x to 5.6.x using mysql repository 5.6.x, you should disable 5.6.x repository and enable 5.7.x repository for upgrading 5.6.x to 5.7.x
for disabling repo
#sudo software-properties-gtk
by checking and unchicking the boxes you can disable or enable the repo’s
If you have data in your MySql 5.5 database, it should be migrated automatically, even it’s better to make a backup before doing a major upgrade.
Being in a production environment is tricky, especially with the level of risk involved. But if you see no need for updating, then keep your old version of MySQL. If you choose to update then remember to backup configuration files and databases.
One more option is there instead of upgrading from 5.5 to 5.6 and again 5.6 to 5.7 the best option is make backup and remove the current version if it is not production server and install latest version of mysql i.e, mysql-5.7.x by configuring the repository and restore the backup.