I wonder if someone can share the experience in terms of my.cnf parameters which helped in achieving better IDO performance in a large scale Icinga2 Cluster deployment.
I’ve to set up 2x MYSQL 8.x nodes with a/a replication between them for Icinga2 2.15 cluster.
This ran pretty well, until we moved to a postgres setup when we switched to IcingaDB. With wsrep_sst_method=mariabackup we had performance and reliability issues though. Switching to rsync fixed that pretty much. No cluster rebuild since then, afair.
Now only the Director and some module DBs remain, though.
Thank you for sharing the information. I appreciate it. One question for you - What made you to switch over to Postgres while switching to IcingaDB? Perhaps some performance gain in comparison to Mysql?