Run MySQL 5.7, RancherOS

docker stop mysql57 && docker rm mysql57

docker run --name mysql57 -e MYSQL_ROOT_PASSWORD="zabbix" -e TZ="Europe/Riga" -p 3357:3306 -d mysql:5.7


curl -Lk "https://cdn.zabbix.com/zabbix/sources/stable/5.0/zabbix-5.0.1.tar.gz" -o zabbix-5.0.1.tar.gz
tar -xvf zabbix-5.0.1.tar.gz

cd zabbix-5.0.1/database/mysql

sudo mv *.sql $(sudo docker inspect mysql57 | jq -r ".[].GraphDriver.Data.UpperDir")

docker exec -it mysql57 bash

cat << 'EOF' > ~/.my.cnf
[client]
host=localhost
user=root
password=zabbix
EOF

mysql

create database zabbix character set utf8 collate utf8_bin;

grant all privileges on zabbix.* to "zabbix"@"%" identified by "zabbix";

FLUSH PRIVILEGES;

exit

mv /*.sql ~

cd

cat schema.sql images.sql data.sql | mysql zabbix

cd /etc/mysql/conf.d
cat << 'EOF' > zabbix.cnf
[mysqld]
skip-log-bin
innodb_buffer_pool_size = 512M
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
max_connections = 2000
innodb_log_file_size = 64M
optimizer_switch=index_condition_pushdown=off

join_buffer_size=256K

innodb_read_io_threads = 8
innodb_write_io_threads = 8
performance_schema = 0
EOF
exit


docker restart mysql57
docker exec -it mysql57 bash

mysqldump --compact --complete-insert --extended-insert \
 --no-create-db --no-create-info --compatible=postgresql \
 zabbix > zabbix-4.4-export-to-postgresql.sql

exit

docker exec -it mysql8 mysql -uroot -pzabbix -e 'select @@sql_log_bin\G'