Suggest the HertzBeat + GreptimeDB + Postgresql Solution for the best performance and stability.
Notes:
MySQL, MariaDB, OceanBase, and TiDB SQL query metrics can use the built-in MySQL-compatible query engine without mysql-connector-j.
If you place mysql-connector-j in ext-lib, HertzBeat prefers JDBC after restart.
Oracle and DB2 still require external JDBC driver jars in ext-lib.
Use Postgresql + GreptimeDB as HertzBeat dependent storage -> HertzBeat+PostgreSQL+GreptimeDB Solution
Use Postgresql + VictoriaMetrics as HertzBeat dependent storage -> HertzBeat+PostgreSQL+VictoriaMetrics Solution
Use Mysql + VictoriaMetrics as HertzBeat dependent storage -> HertzBeat+Mysql+VictoriaMetrics Solution
Use Mysql + IoTDB as HertzBeat dependent storage -> HertzBeat+Mysql+IoTDB Solution
Use Mysql + Tdengine as HertzBeat dependent storage -> HertzBeat+Mysql+Tdengine Solution