Secure connections to Zabbix database It is now possible to configure secure TLS connections to MySQL and PostgreSQL databases from: • Zabbix frontend • Zabbix server or proxy Restricting agent checks Memcached instances (see description). MySQL monitoring plugin A MySQL plugin for Zabbix agent 2 is now available as part of the out-of-the-box monitoring of MySQL instances (see description). Agent 2 Minimum required versions updated The minimum required versions for supported databases now are: • MySQL 5.5.62 • MariaDB 10.0.37 • PostgreSQL 9.2.24 • Oracle 11.2 TimescaleDB native compression support

Parameter structure for Zabbix agent 2 plugins has been updated: • For Ceph, Docker, Memcached, MySQL, Oracle, and Redis plugins, a Uri can now only be specified as a named session parameter. • For line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1804 4 Monitor MySQL with Zabbix agent 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . code points (instead of 255 in previous versions). A longer value will be truncated. Note that on MySQL, the effective maximum length in characters will be less if the returned value contains multibyte entered, such as scripts, expressions, macro values, etc. Miscellaneous Database TLS connection for MySQL on SLES 12 The packages for server/proxy installation on SUSE Linux Enterprise Server version 12

performance. Starting from Zabbix 6.0, the following database versions are officially supported: • MySQL/Percona 8.0.X • MariaDB 10.5.X - 10.6.X • PostgreSQL 13.X - 14.X • Oracle 19c - 21c • TimescaleDB for MySQL/MariaDB, PostgreSQL, TimescaleDB v1 and v2, and Oracle. 14 utf8mb4 support for MySQL utf8mb4 encoding with utf8mb4_bin collation is now supported for Zabbix installations with the MySQL/MariaDB MySQL/MariaDB database. Previously only utf8 encoding was supported, which with MySQL stands for utf8mb3 encoding and thus supports only a subset of proper UTF-8 characters. In the new version utf8mb4 support

item, referencing the current host sum(last_foreach(/*/vfs.fs.size[/,total]?[group=”MySQL Servers”])) grpsum[”MySQL Servers”,”vfs.fs.size[/,total]”,last] Aggregate calculation (formerly, aggregate performance. Starting from Zabbix 5.4, the following database versions are officially supported: • MySQL/Percona 5.7.28-8.0.X • MariaDB 10.0.37-10.5.X • PostgreSQL 10.9-13.X • Oracle 12.1.0.2 - 19c • available allowing to monitor validity and expiration dates of TLS/SSL website certificates. • Plugins MySQL and PostgreSQL now support encrypted TLS connection between the agent and monitored databases. TLS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1862 4 Monitor MySQL with Zabbix agent 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . command-line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows by extending it by Hostname value from the config file zabbix_agentd --print zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf zabbix_agentd.exe -i zabbix_agentd.exe -i -m -c zabbix_agentd

line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m requires a separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle or IBM DB2 is at your own risk and may contain some limitations as,

常见问题 1. Q：可以更新或清空队列（如菜单 “管理”→“队列” 中所展示的队列）？ A: 不可以。 2. Q: 如何从一个数据库迁移到另一个数据库？ A: 只需要转存数据 (对于 MySQL, 使用参数 -t 或 --no-create-info), 用 Zabbix 的 schema 文件创建新的数据库，并导入数据。 3. Q: 想用下划线替换监控项 key 中的所有空格，因为空格只在老版本中起作用，而在 Administration → Queue)? A: No. 2. Q: How do I migrate from one database to another? A: Dump data only (for MySQL, use flag -t or --no-create-info), create the new database using schema files from Zabbix and import should be imported (no images.sql nor data.sql) MySQL shell> mysql -uroot -p mysql> create database zabbix character set utf8 collate utf8_bin; mysql> grant all privileges on zabbix.* to zabbix@localhost

Templates The template Azure by HTTP has been updated and now includes metrics to monitor Microsoft Azure MySQL servers out-of-the-box. You can get this template: • In Configuration → Templates in new installations; line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m

will be set to 0.0001 seconds. 3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It contained a complex bash expression and was failing if the line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m