Consultation on MySQL configuration requirements

[salavie]

Hello everyone

According to the official documentation provided for the hardware configuration example of the Zabbix server, monitoring 100000 monitoring indicators with Zabbix 6.0 requires a 16C64G server

If we put MySQL 8.0 on a separate server, does the MySQL server also require a 16C64G configuration?

How many configurations of MYSQL server can be used for the subsequent 7T database?

[DanielZhang]

According to the hardware configuration example provided by Zabbix 6.0 official documentation, the requirements for a standalone MySQL 8.0 server differ from those of the Zabbix server. Although the official documentation does not specify the exact configuration requirements for the MySQL server, typically, the configuration of the MySQL server depends on factors such as the size of the database, concurrency levels, and required performance.

For a subsequent 7T database, you may need a higher-spec MySQL server to handle such a large-scale database. Generally, dealing with databases of this magnitude may necessitate considerations such as employing more CPU cores, larger memory capacity, and faster storage devices to ensure the performance and reliability of the database.

However, the specific configuration of the MySQL server depends on various factors, including but not limited to expected read/write loads, data access patterns, data backup and recovery requirements, etc. It is recommended to conduct performance testing and load testing evaluations to determine the MySQL server configuration that best suits your needs.

What confuses me is why you would need to store 7TB of Zabbix data. I have 400,000 monitoring items, my machine only has 1TB of space, and the database trend graphs only retain 365 days of data, with the rest being kept for just 30 days. Currently, my database and host are working fine.

16C64G is good choice

[cyber]

I suspect those values are for "all-in-one" server, where you have everything, GUI, server, DB. Most of that power goes to DB, I think.
If you put DB on separate host, Then it might not need that big one, might get away with half of it... but it might need some testing.
You also need much smaller one for server. 4C12G handles 12k hosts and 1.1 million items with ease... But there are proxies also, so server does not do any polling, only deals with data collection and trigger calculations.