Score:0

Zabbix DB connection support DNS SRV Records

tc flag

I have Zabbix Mysql 3 node Innodb cluster, which gives 3 DNS SRV Records with Mysql Router endpoints. I need to configure Zabbix server and web DB connection as DB host (e.g _mysql._tcp.example.com), but it doesn't work.

Are the any configuration parameter Zabbix offer that will allow to enter DNS SRV records? OR Is there an alternative available.

Nikita Kipriyanov avatar
za flag
Do you want to monitor this MySQL or to store Zabbix's own database in it? In latter case, according to the [documentation](https://www.zabbix.com/documentation/current/en/manual/installation/frontend#configure-db-connection), you have to specify the exact connection connection information, it doesn't support quering DNS SRV. However, if you want just to discover databases to monitor, you may write your own template with the discovery through DNS SRV.
Ritz avatar
tc flag
Thanks Nikita, yes, I want to store Zabbix own database into 3 Node Mysql Cluster. As DNS SRV query not supported by default, I was thinking to use HAproxy that resolve DNS SRV records and allow failover configuration to cover Mysql Resiliency.
Score:0
za flag

Well, Zabbix's database connector does not use DNS SRV records to locate the database. According to the manual, you need to provide the exact connection details.

Using haproxy to make database reliable should be possible.

As I see you are trying to build highly available solution here, make sure you've read the Zabbix's own documentation regarding that. Also "MySQL cluster" might mean different things; if you meant Galera cluster then I'm afraid that wouldn't be the best possible solution. The Zabbix database usage pattern is to write many small records into few tables (one table per handled data type), which might be not the best usage pattern for the Galera. The standard primary-standby (or "master-slave") database replication is the best match to the Zabbix's built-in HA capability.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.