Zabbix 4 Network Monitoring - Third Edition

Using data in a remote site

We covered data retrieval on the Zabbix server. But what if we have a remote site, a Zabbix proxy, a powerful proxy machine, and a slow link? In situations like this, we might be tempted to extract proxy data to reuse it. However, the proxy stores data in a different way than the Zabbix server.

Just like in the previous chapter, run the following command:

$ sqlite3 /tmp/zabbix_proxy.db

This opens the specified database. We can look at which tables are present by using the .tables command:

sqlite> .tables  

Notice how there're still all of the history* tables, although we already know that the proxy doesn't use them, opting for proxy_history instead. The database schema is the same on the server and proxy, even though ...