Upgrading MySQL without uninstalling Zabbix

[bkowalewski]

For security reasons, we need to upgrade MySQL from 5.5.40 to 5.5.47 on our proxies that have the database on the same host as the proxy. This involves an actual uninstall and reinstall of MySQL, not just a yum update. Zabbix package dependencies do not like this, and we are wondering about doing the upgrade while ignoring dependencies. Has anyone done this MySQL upgrade? How did you do it?

We are currently Zabbix 2.4.3 on linux, Centos 6, with a server and 16 proxies, around 450 values per second.

Thanks.

[LenR]

Would yum-plugin-replace work for this?

If not, if you remove mysql, then reinstall mysql and zabbix, the config files should be untouched.

I have my proxies setup so root has a .my.cnf file for the zabbix proxy mysql user. Then a simple script will create the db:

#!/bin/bash
mysql < create_db.sql
cd /usr/share/doc/zabbix-proxy-mysql*/create
mysql zabbix < schema.sql
cd

[bkowalewski]

Thanks for the reply.

Since, we don't uninstall and reinstall production systems casually, as a policy, I am trying to do this without the uninstall, since it would require a complete regression test of a Zabbix proxy, as we would do for an upgrade. Since we are in the midst of testing 3.0.3, our test Zabbix environment is occupied right now.

I'm hoping to find someone who has done the upgrade without the Zabbix uninstall/reinstall, so we don't need to build a second Zabbix test environment.