Zabbix Basic concept understanding

[shayan]

kindly help me to clear following.

01. what is the best practices for monitoring the windows /linus based servers (SNMP based on Agent based).
02. for production case can we go ahead with MySQL (is there any limitation for MySQL like maximum size limitation with SQL Express (maximum size 10GB for SQL express DB)).
03. We need to monitor Cisco 3650 Switch, which is configured as on Stack (two switches connected with stack cable and configured. so both switches act as a single switch). we have configured a single Management IP address (vlan address) for these switch (stack master hold the management ip address). can we able to monitor the both switches (CPU, Memory, interface utilization, etc) using the single management ip address (configure host with the management ip address on zabbix).

[LenR]

#1 IMHO Agent (Active) for most items is best for servers. It's useful to have a dev-ops DSC tool (like puppet) to configure your hosts.

#2 I'm not aware of any MySQL size limit, we're over 3Tb with RHEL 7.5 and mysql-community-server-5.7. If you're going to to have a big database, look at the discussion of history & trends housekeeping vs. DB partitioning https://zabbix.org/wiki/Docs/howto/mysql_partition

#3 Will snmpget or snmpwalk show the data you need? If it can, then Zabbix should be able to get it also, but it may not be a supplied template.