Using Zabbix with MMM

[dsgnr]

Hi all, I am doing some experimentation with my homelab. I'd like to utilise MMM (http://mysql-mmm.org/) where I have two or more database instances, one is a writer only, and the others are read only.

Is there a way to do this within Zabbix? I'm yet to find anything where you can specify different IP addresses for db instances with different roles.

'm not having issues with scaling or anything like that. It's purely a learning exercise.

Thanks
Dan

[ingus.vilnis]

Hi Dan,

Zabbix components (both backend server and web frontend) require both read and write operations to the database. Having e.g frontend for read-only users pointed only to a read only database sounds like a tempting idea but in reality the web interface still requires writes for different purposes. Also pointing e.g. server to one DB master and Frontend to another DB master also may lead to data corruptions of the DB replication goes out of sync.

Still an interesting exercise and much more practical one in the real production environment would be to set up MySQL with GTID replication, both nodes slaves to the other. And then use the Virtual IP which is pointed only to one of the databases. use the DB VIP then in both Zabbix Server and frontend configs. In this case you will have much higher site reliability.

Or you can also experiment with some other clusters like Percona XtraDB Cluster and then tell what is the difference.

Cheers!