InfluxDB is time series database that can store huge amount of data for different metrics like CPU, RAM, Storage usage. If you have Grafana in place, one of the databases that would work with it is InfluxDB.
If you setup InfluxDB you can type
Databases in InfluxDB are called well Database :) and tables are called
You are now on
Yes, it is almost similar to MySQL. The main point of such a database is to use monitoring tool in place and push metrics into influxDB, then make graphs by using Grafana.
#influxdb #grafana #measurement #time_series_db
If you setup InfluxDB you can type
influx
and hit enter to see InfluxDB console (like MySQL):infladmin@my_host:~$ influx
Connected to http://localhost:8086 version 1.2.2
InfluxDB shell version: 1.2.2
Databases in InfluxDB are called well Database :) and tables are called
Measurement
. To see list of all databases and make a database active do as below:> SHOW DATABASES
name: databases
name
----
_internal
my_db
monitoring
some_other_db
> USE my_db
Using database my_db
You are now on
my_db
database. To display list of measurements (table) and query it:> SHOW MEASUREMENTS
name: measurements
name
----
cpu_stat
mem_stat
> SELECT * FROM cpu_stat LIMIT 2;
name: cpu_stat
time my_tag metric value
---- ----------- ------ -----
1503999476000000000 CPU_CORE3 CORES 0
1503999476000000000 total 16
Yes, it is almost similar to MySQL. The main point of such a database is to use monitoring tool in place and push metrics into influxDB, then make graphs by using Grafana.
#influxdb #grafana #measurement #time_series_db