enable zabbix HA for SQL data base , zabbix server ,and zabbix fronetend

[eladko21]

hey everyone
I'm using Zabbix 6.0 lts server on Linux server jammy
I'm trying to enable HA for Zabbix server and SQL database
i succeed to enable it when using the same database for each node
but when i created a second SQL database and start replication between the two data bases then
i assign database for each node and now the slave node recognized by the server as stooped condition and the fail over wont work
i would be happy if someone would be able to help with that problem
thanks

[um3n]

Hey,

what do you try to accomplish?

The zabbix-server HA mechanism is a active/passive. They both use the same database-server to work and communicate with each other.
If you want to have a database-cluster as well, you need a DBMS-Cluster like galera with mariadb and in zabbix you would use the same IP to connect to the cluster.
If you use two different database nodes (even with some kind of replication) you probably would have write-problems within your DBMS.