How to monitor application performance through mysql?

Question

Monitoring

I administer the application. The application is written specifically for our office. There is no monitoring at all, and it is not expected that it will be possible to finish any monitoring. they will ask for money. However, the application constantly writes the results of its work to the mysql database.
Monitoring the view "is the port open on a specific machine" and "is the process running there" is not enough for me, not to mention the loading of hdd or cpu .. We need the results of a specific method (the results are written again in sql) with timely notification.
What will be most convenient to use to set up such monitoring?
It is necessary to periodically query the database, draw a graph based on the received data, for example, with a specific type of errors for the selected period, store data for 3 months, in case of unsatisfactory statistics - notification (cart, mail).
I saw that there is an option to roll out an add-on for zabbix so that it can work with sql queries. Is this the best solution?

Answer 1

1. Determine what exactly you want to monitor in the database, make a request to get a critical parameter
2. Write a script - even in bash, even in python, which will execute the request from step 1
3. Fasten zabbix_sender (console or as a python module) , which will transfer the result of the request execution to Zabbix
4. Register the call of this farm through cron
5. Profit!

Answer 2

Zabbix can fetch data from external databases.
https://www.zabbix.com/documentation/5.0/manual/co...
On the zabbix server, you need to configure odbc and that's it, you can create elements that will send queries to the database.