MySQL 8 monitoring via ODBC

Create proxy:

docker run --name mysql8mon -e ZBX_HOSTNAME=mysql8mon -e ZBX_SERVER_HOST=10.133.253.43 -e ZBX_STARTPOLLERS=1 -e ZBX_STARTPREPROCESSORS=1 -e ZBX_STARTTRAPPERS=0 -e ZBX_STARTDBSYNCERS=1 -e ZBX_STARTDISCOVERERS=0 -e ZBX_CACHEUPDATEFREQUENCY=3600 -e ZBX_STARTPINGERS=0 -e ZBX_STARTHTTPPOLLERS=0 -d zabbix/zabbix-proxy-sqlite3:centos-4.4-latest

Move to container:

docker exec -it mysql8mon bash

Install MySQL 8 official repository:

rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Install ODBC connector:

yum -y install mysql-connector-odbc

Set ODBC relation:

cd /etc
cat << 'EOF' > odbc.ini
[mysql8mon]
Description = MySQL 8.0
Driver = MySQL ODBC 8.0 Unicode Driver
Database = zabbix
Server = 10.133.112.87
User = root
Password = zabbix
Port = 3306
EOF

Test connection:

isql -v mysql8mon

Exit client:

quit