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:
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
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:
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
Comment