How to collect SNMP data from D-link switch in mysql database?

Question

MySQL

There is a network, about 500 end devices connected to D-link DES 1228/ME switches.
These switches allow you to collect very different statistics, and if I'm not mistaken, then the state of the ports as well. Up/Down
Interests - how it is possible to receive the data on a status of ports and to bring in a separate DB mysql?
Maybe someone came across or met materials on this topic?

Answer 1

The problem was solved in this way:
less /var/tmp/tkd_1/new:
1 Up
2 Down
3 Down
4 Up
.....
Comparing files with the results of the last 2 checks.
Changes in the state of the port are written to the MySQL database.

Answer 2

If you have enough nodes, can you use specialized software - Zabbix, Zennos, Nagios, MRTG, Cacti, etc.?
You can, of course, store it in a database, but after all, this monitoring data must not only be accumulated, but also displayed in a readable form, report events, etc., so I recommend that you still use a monitoring system.
MRTG and Cacti are simpler, Zabbix, Nagios are "full-featured combines".
Choose which one you like best and go ahead!
I would recommend Zabbix to you. There is also a version for mysql.

Answer 3

well, in php how is it possible

$connect_to_device = new SNMP(SNMP::VERSION_1, "127.0.0.1", "public");