I use the "MySQL by Zabbix Agent 2" template on 7.0.0alpha1.
I have 3 mysql servers in an InnoDB Cluster.
Recently, this cluster broke and set all my nodes to read-only, because I added a database with a table that did not have a primary key. But I did not know it was broken until a few days later when I was reviewing emails received by service accounts on my server. Zabbix doesn't use this database cluster because innodb cluster does not support foreign keys with cascading, which is used extensively in the zabbix database.
Can an item be added to the built in template that triggers when the global "read_only" variable gets set to 1 (also known as ON)?
I have 3 mysql servers in an InnoDB Cluster.
Recently, this cluster broke and set all my nodes to read-only, because I added a database with a table that did not have a primary key. But I did not know it was broken until a few days later when I was reviewing emails received by service accounts on my server. Zabbix doesn't use this database cluster because innodb cluster does not support foreign keys with cascading, which is used extensively in the zabbix database.
Can an item be added to the built in template that triggers when the global "read_only" variable gets set to 1 (also known as ON)?