Zabbix HA with Mysql replication
I'm having two Zabbix server 1)primary and 2)secondary each is having it own database mysql 5.7
Monitoring all the server using active check it will agent push the data to both primary and secondary.
As I'm having two server with two database . When i'm adding host or configurating any trigger. I need to replicate on the secondary server too. Is there any way to replicate the exact zabbix database tables.
I know we can't use database cluster if I use there will be deadlock happens. I need to exclude the exact history and events like tables from replication.
Does anyone know how to do it? I know it is a bit risk task. But it can be done. Waiting for your valiable reply.
Monitoring all the server using active check it will agent push the data to both primary and secondary.
As I'm having two server with two database . When i'm adding host or configurating any trigger. I need to replicate on the secondary server too. Is there any way to replicate the exact zabbix database tables.
I know we can't use database cluster if I use there will be deadlock happens. I need to exclude the exact history and events like tables from replication.
Does anyone know how to do it? I know it is a bit risk task. But it can be done. Waiting for your valiable reply.