MySQL 8 vs MariaDB 10 for a new installation (~1000NVPS)

[alexthefifth]

Hello all,

Assuming all other variables are the same, which would you recommend for Zabbix?

MySQL and MariaDB used to be fairly interchangeable, but have been deviating more and more in the newer releases.

The plan is to tweak them as per the most common community suggestions, in particular those are:

- Use InnoDB as the engine
- Table partitioning and disable housekeeper (in this case we will be retaining history and trends for 90 days, partitioning daily)

Going to assume that no proxies nor agents are being used for easier comparison. Passive polling only.
To keep things fair, going to assume we're using the free MySQL "Community Edition"
Lots of RAM, lots of CPUs etc


The only relevant benchmark I've been able to find is here: https://www.softizy.com/blog/mariadb...s-ibm-power-8/
It seems that MySQL is the clear winner when you need a lot of NVPS
In particular, the benchmark where query cache is disabled seems to be most relevant to the Zabbix database usage patterns?
What's particularly impressive is how well MySQL performs even without thread pooling support

Thoughts?

Edit: another benchmark that puts MySQL ahead of MariaDB: https://www.researchgate.net/publica..._OLTP_workload

[steeladept]

Those benchmarks look very outdated, but I can't say I can find much newer. MySQL 8 is fairly new - 6 months old at most - for use with Zabbix, but I found many of the features of the newer database worth using it over the older tried and true. Since MariaDB is written to be drop-in replaceable, I would assume there is very little real-world difference. If I had a choice, knowing what I know now, I would probably go MariaDB since it is OSS software, until such time as it proved unable to fit my needs (at which time I would test the drop-in replacement statement ). That said, I went with MySQL Community Edition when I started.

You can read this thread of this room for a little more information: https://www.zabbix.com/forum/zabbix-...ations-request

The only issue I have is the script does not delete old partitions like it is supposed to. I have not yet taken the time to troubleshoot that, since I do not know Pearl that well. Another user said it works fine for them with MariaDB, so not sure if it is DB related, or script related (or just the interface between the two as the user implies). Either way, that is the only reason I would *recommend* MariaDB over Oracle MySQL. Others may have other reasons, or recommend something different all together, but the generic Oracle MySQL Community edition is working fine for me at ~2100 NVPS right now (with 8 proxies each running ~between 250 - 350 NVPS).