Spinning circle bothering screens

[christianlll]

Hi people, new with zabbix. Taking 5 servers already running (server, 2 proxies, mariadb and frontend).

When going to screens (sometimes) it gets slow and a spinning circle appears over system group, over host group issues, and so on.

Any idea on what might be the culprit and how to solve it?

Thanks in advance!

[kloczek]

Looks like slow DB backend.

[christianlll]

Txs for your response Kloczek! Will be migrating DB to galera cluster and let you know!

[kloczek]

Such slow DB issue is more likely related to not enough memory given to DB engine than scaling it horizontally.
If you will have two galera nodes with exactly the same memory like now your single node than still you will have the issue with low misses/hits ratio on serving db content out of data already cached in the memory.
Despite this factor galera will have higher latency on write new data speed than single node (because write operation needs to be confirmed by both nodes).
In other words: change to galera will not solve your current problems and will add even new ones.

[christianlll]

Understand Kloczek! Thanks for explaining!

However this is a go (so far) so will be sharing my result here!