---

Subject:	RE: Zenoss 4.2.5 - autodeploy installation - mysql-community-server-8.0.27
Author:	Michael Rogers
Posted:	2022-02-03 13:28

Sam,

According to the Zenoss Core 4.2 Installation Guide:

"Zenoss Core requires at least MySQL 5.5.25, and supports later versions through 5.5.35."

It's possible that it will work on versions higher that 5.5.35, but it was not explicitly tested during the 4.2 lifecycle.  It may be possible to upgrade to MySQL Community Server v8 without breaking anything, but I have no way to assure you in either direction.  Some recommendations:

1. Take a backup.  If you plan to do a mysqldump, make sure that Zenoss is stopped first.  Also, restoring a mysqldump will not restore the object database catalogs or the event database Lucene indices.  These would require rebuilding and the steps are documented if it comes to that.
2. If this is a VM, do a full shutdown and get a fresh snapshot.
3. It may be possible to do a side-by-side install of mysql, load the old database into the new instance, and point the Zenoss config files to the new location.  This may make it easier to roll back in case of failure, but restoring from a VM snapshot may be easier still.

Mind you, all of this assumes that MySQL Community Server v8 supports databases created under v5.  (Side note - I've seen plenty of forum posts in my day where someone qualified a statement with IANAL ("I am not a lawyer").  I think we can advocate here for new acronym - IANADBA ("I am not a database admin").  There may be additional conversion or alteration steps that I'm unaware of.

If you opt to go ahead with testing, let us know your results?

------------------------------
Michael J. Rogers
Senior Instructor - Zenoss
Austin TX
------------------------------