How to install Grafana in Rpi

https://grafana.com/

Protocol:

1)  Detect my RPi CPU:

    $ cat /proc/cpuinfo
        processor    : 0
        model name    : ARMv6-compatible processor rev 7 (v6l)
        BogoMIPS    : 697.95 38.40
        ..

         So my RPi B+ ARMv6 cpu.

2) Download Grafana for ARMv6

from https://grafana.com/grafana/download?platform=arm

Choose the version corresponding with the cpu, copy and execute commans in your RPi console.

Ubuntu and Debian(ARMv6)

    $ sudo apt-get install -y adduser libfontconfig1
    $ wget https://dl.grafana.com/oss/release/grafana_7.3.6_armhf.deb
    $ sudo dpkg -i grafana_7.3.6_armhf.deb

     ...

    ### NOT starting on installation, please execute the following         statements to configure grafana to start automatically using         systemd

     sudo /bin/systemctl daemon-reload
     sudo /bin/systemctl enable grafana-server

    ### You can start grafana-server by executing
     sudo /bin/systemctl start grafana-server

Execute the indicated command if you want start Grafana at boot.  

3) Start Grafana server:

    $ sudo service grafana-server start

4) Web Access to Grafana:

Using web browser in address [Grafana host IP]:3000

 

5) First login to Grafana:

Default user: admin
Default password: admin

Change your password and enter into Grafana:

7) Create new source of data from MariaDB

If you have your database in different host, allow remote access in database server: http://misnotaslinux.blogspot.com/2021/10/allow-access-to-mysqlmariadb-from.html

Add new data source:

Select MySQL:

 

Fulfill database access data:

 

... Save&Test

 

8) Make a Grafana panel

 

 Start to design graph, tables, etc.

 

Links:

https://andreea-sonda31.medium.com/monitor-raspberry-pi-resources-and-parameters-with-grafana-board-part-1-ab0567303e8

https://websiteforstudents.com/allow-remote-access-to-mariadb-database-server-on-ubuntu-18-04/