MySQL 5.7.12 compatibility warning

[arnosim]

We would like to upgrade our Zabbix servers that we are using internally, the current version that we are using is 5.2 and we want to upgrade to 5.4.
We are using a AWS managed MySQL cluster (RDS aurora) this version of MySQL is 5.7.12. AWS is saying the following:

Please note that the compatibilities of MySQL 5.7.28 are implemented through the Aurora version and Zabbix application is getting MySQL version as 5.7.12 but not taking the aurora version.

It seams that AWS is not going to update to 5.7.28.

The error that we are viewing is the following:

Unsupported DB! MySQL version is 50712 which is smaller than minimum of 50728

I have the following questions:

1. Is there any way to manipulate or skip this this check (via a configuration change)? We would like to see if the upgrade is working.
2. Is there any documentation online about why MySQL 5.7.28 is required?
3. Any people out there that had this same issue and resolved it (in another way)?

Kind regards,

Arno

[Markku]

5.4 is not supported anymore, 6.0 has AllowUnsupportedDBVersions setting: https://www.zabbix.com/documentation.../zabbix_server

Markku

[arnosim]

Hi Markku,

Thank you for the reply. We will try to upgrade the server to Zabbix 6.

[arnosim]

I have an update, we tried the option above: We installed Zabbix 6 with AllowUnsupportedDBVersions set to 1 in zabbix_server.conf

The following error remains:

May 31 14:05:45 zabbix05 zabbix_server[10493]: Error! Current MySQL database server version is too old (5.07.12)
May 31 14:05:45 zabbix05 zabbix_server[10493]: Must be a least 5.07.28

[Markku]

What is the actual reason for you not being able to run newer MySQL version in Amazon RDS?

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html

"Amazon RDS supports DB instances running several versions of MySQL. You can use the following major versions:
MySQL 8.0
MySQL 5.7
"

Markku

[arnosim]

Hi Markku,

Thank you for the reply.

The actual reason is that we are depended on AWS to update AWS Aruora RDS. As far as I understand we (the customer at AWS) are depended on AWS to be able to upgrade to a newer (minor) version.

I opened up a AWS support case with the following questions at AWS:

Q: Why does MySQL not reflect version 5.7.28, this version was mentioned before by AWS support? (Another case was opened regarding this issue).
A: Aurora versions use the major.minor.patch scheme. An Aurora major version refers to the MySQL or PostgreSQL community major version that Aurora is compatible with Amazon Aurora versions:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.VersionPolicy.html

How often Amazon Aurora minor versions are released

In general, Amazon Aurora minor versions are released quarterly. The release schedule might vary to pick up additional features or fixes.

We have this problem at least half a year.

Q: Is there any (good / secure) way to update the version so that we can upgrade our Zabbix server without problems? (asuming that Zabbix checks the version using the MySQL query).
A: As Aurora major version 2.10.1 does use MySQL community version 5.7.12 and the compatibility issue is due to Zabbix, to better assist you with this I would request you to work with Zabbix support to check the compatibility for Zabbix and if there is a workaround for this. As this is out of scope for AWS Premium Support on a best effort basis, I was able to find a third party Zabbix forum post where other users were experiencing similar error messages. I hope this will provide extra guidance kindly see below

In the mean time we updated to 2.10.2 (no version change there). As you can see they are referring to Zabbix.

I also thought about upgrading to MySQL 8, but we do not have such a cluster at the moment and this would mean that we need to upgrade one or create another cluster. This will cost more money because more time or resources is needed.

Kind regards,

Arno

[Markku]

Ok, so the reason is that you want to save money by using the already-existing RDS database (that is based on older MySQL), and that is unfortunately not compatible with Zabbix.

Markku

[arnosim]

We have successfully replaced our Aurora RDS cluster from 5.7 to 8.0. This worked for us.

We upgraded from Zabbix 5.2 to 6.0.

I consider this topic closed.