High-Availability database cluster for Zabbix

[Spectator]

Are any of you using a high-availability database cluster for Zabbix 6?
I would also be interested in MySQL (MariaDB) or PostgreSQL.
Can you provide a step-by-step description of how to create a high-availability database cluster that works automatically without manual intervention and cannot cause deadlocks?
It would be practical for the database cluster to have a virtual IP address, which is always used by the current master DB server, and I could set this virtual IP address in Zabbix as the database IP address.

Why am I asking? I saw the description of several solutions, in the comments of which I read similar concerns as in this topic:

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/369686-problem-with-mariadb-galera-cluster-deadlock-wsrep-aborted-transaction

And here they write superficially about something that I think is necessary for a database cluster and Zabbix:
https://dba.stackexchange.com/questi...us-replication

[DaLoZ]

We use a high-availability MSSQL cluster and have a virtual hostname / IP for every instance. We've created a host in Zabbix for every instance with the agent pointing to their virtual hostname.
So far no issues.

[Spectator]

Dear DaLoZ,

Thank you.
As far as I know, Zabbix does not officially support the MSSQL database backend. Why did you choose this database?

https://www.zabbix.com/documentation/current/en/manual/installation/requirements