Zabbix and MySQL 5.6

[lastgraywolf]

Hello

My customer is using MySQL 5.6 in production environment and they will upgrade it in mid term future. But they are looking for monitoring solution.
I know MySQL 5.6 is very very old release but to monitor MySQL environment is extremely important.
Current version of Zabbix does not support MySQL 5.6, as far as I know. So what version of Zabbix should I install ?

Thanks

[Atsushi]

What you want to achieve is to monitor your MySQL 5.6 environment? Or is it building a Zabbix environment using MySQL 5.6? If you just want to monitor the MySQL 5.6 environment, you can prepare a separate database environment for the Zabbix server version. If you want to use MySQL 5.6 as the database for Zabbix, you should use Zabbix 4.0 LTS. Zabbix 5.0 seems to require MySQL 5.7 or later. Zabbix 5.2 is no longer supported. Zabbix 5.4 will be discontinued at the end of this month.
There are some points to note. In order to build Zabbix server environment and use all functions, it is necessary to have a relatively new version of OS, libraries, and middleware. If you want to build your environment using the official package repository, you are limited to a specific OS and version.

Requirements(Zabbix 4.0)

https://www.zabbix.com/documentation/4.0/en/manual/installation/requirements

Requirements(Zabbix 5.0)

https://www.zabbix.com/documentation/5.0/en/manual/installation/requirements

Requirements(Zabbix 6.0)

https://www.zabbix.com/documentation/current/en/manual/installation/requirements

Zabbix Life Cycle & Release Policy

https://www.zabbix.com/life_cycle_and_release_policy

Download and install Zabbix

https://www.zabbix.com/download

[lastgraywolf]

Hello Atsushi

Thanks for your response

I just want to monitor MySQL 5.6; so want to create alarms, dashboards and etc regarding to MySQL 5.6 databases. I think I will use PostgreSQL for Zabbix backend (I am good at PostgreSQL )
Customer has lots of MySQL 5.6 environments (with Percona XtraDB) to monitor.

I am asking this question because there is a info about it like (https://www.zabbix.com/integrations/mysql)

For Zabbix version: 6.0 and higher
The template is developed for monitoring DBMS MySQL and its forks.
This template was tested on:

• MySQL, version 5.7, 8.0
• Percona, version 8.0
• MariaDB, version 10.4

But I could not find any note or release info about MySQL 5.6 monitoring support

So what Zabbix version I sholud use ?

Thanks

[lastgraywolf]

Hello there

any input about MySQL 5.6 monitoring ?

any version recommendation ?