Visualizing data from ESP32 microcontrollers using MySQL and Grafana

Now, let’s finish off our implementation of a real-time temperature and humidity system. For this, we are going to use Grafana to create our reports and MySQL as our source of data to feed the reports. You can deploy this software in Kubernetes in the cloud or a private cloud using a network that can be accessed by your edge clusters. In this section, we are assuming that we are using Kubernetes in the cloud. To start creating our reports, follow these steps:

1. Create the necessary namespace monitoring:

   $ cat <<EOF | kubectl apply -f -
   apiVersion: v1
   kind: Namespace
   metadata:
     creationTimestamp: null
     name: monitoring
   spec: {}
   status: {}
   EOF

2. Create a ConfigMap to create a default data source that contains our MySQL connection:

   $ cat <<EOF | kubectl apply -f -
   apiVersion: v1
   kind: ConfigMap
   metadata:
     name: grafana-datasources
     namespace: monitoring...